View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elisabeth D Elisabeth D is offline
external usenet poster
 
Posts: 18
Default 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