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.
Bookmarks