| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning Zero
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 | |
|
|
Similar Threads
|
||||
| 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) | |||
Threaded Mode
