| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
nno result if one cell empty
One way:
=IF(G12="","",IF(H12="","",H12-G12)) Elisabeth "Gazman" wrote: =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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
nno result if one cell empty
One way:
=IF(COUNT(G$12:H$12)<2,"",H$12-G$12) -- Biff Microsoft Excel MVP "Gazman" wrote in message ... =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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
nno result if one cell empty
Thankyou both very much for your help!
"T. Valko" wrote: One way: =IF(COUNT(G$12:H$12)<2,"",H$12-G$12) -- Biff Microsoft Excel MVP "Gazman" wrote in message ... =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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
nno result if one cell empty
You're welcome!
-- Biff Microsoft Excel MVP "Gazman" wrote in message ... Thankyou both very much for your help! "T. Valko" wrote: One way: =IF(COUNT(G$12:H$12)<2,"",H$12-G$12) -- Biff Microsoft Excel MVP "Gazman" wrote in message ... =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 |
| Reply |
| 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 | |||
Hybrid Mode
