Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=IF(OR(A12=0,B12=0),0,MAX(A12-B12,0))
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Silvercreek" wrote in message ... I use the MAX command for negative numbers when a positive number is subtracted from zero or empty cells, returning a negative number, but that does not work when subtracting zero or empty cells from a positive cell. Is there a formula that will return a zero if either of the values in any of the cells being subtracted is empty or a formula that would cover both situations? Thanks -- Silvercreek |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP returning value when range_lookup false | Excel Worksheet Functions | |||
My IF in Excel formula is not returning the correct value. | Excel Worksheet Functions | |||
vlookup not returning full field value (text) | Excel Worksheet Functions | |||
LOOKUP returning value in cell above what I was searching for | Excel Discussion (Misc queries) | |||
MY VLOOKUP IS RETURNING N/A AND THEREFORE MY TOTAL SUM AT THE BOT. | Excel Discussion (Misc queries) |