| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
nno result if one cell empty
=IF(ISNA(H$12-G$12),"",(H$12-G$12))
Hi I would like no result, blank cell, if h12 or g12 is empty but keep getting negatives if one cell is empty. The above formula does'nt work. Hope someone can help. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Empty Cell Result | Excel Worksheet Functions | |||
| Formula result as real empty/blank cell | Excel Worksheet Functions | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| When I SUM cells & 1 is empty I need the result to be empty not 0 | Excel Discussion (Misc queries) | |||
| is statement with an empty cell as result | Excel Worksheet Functions | |||
Threaded Mode
