+ Reply to Thread
Results 1 to 3 of 3

Generating calculation if referenced cells contain specific numbers

  1. #1
    Registered User
    Join Date
    11-10-2012
    Location
    Washington DC
    MS-Off Ver
    Excel for Mac 2008
    Posts
    6

    Generating calculation if referenced cells contain specific numbers

    I'm trying to generate a calculation in a cell if a specific cell in the same line contains one of 3 certain numbers. If the desired numbers are not present, then I want the result to be 0

    The following formula works if the desired numbers are present:

    N75=IF(ISNUMBER(MATCH(A75,$E$750:$E$752,0)),(-(A9*B12)/3))

    If the numbers referenced in E750:E752 (which are 21, 125 and 250) are not present, the result in N75 is "FALSE" instead of 0

    How do I obtain the desired 0 result instead of FALSE?

    Thx in advance for the assistance.

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Generating calculation if referenced cells contain specific numbers

    you can add ,0 at the end

    .......(-(A9*B12)/3),0)
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Registered User
    Join Date
    11-10-2012
    Location
    Washington DC
    MS-Off Ver
    Excel for Mac 2008
    Posts
    6

    Re: Generating calculation if referenced cells contain specific numbers

    Thanks very much. Problem solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1