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

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

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

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

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