excel

[kristineadennettlmC]

HI I have an Excel problem:

I am trying to do a What if problem: =IF(H2 cell is empty then (SUM(H2-G2)

I keep getting error notice, how do I fix this

[#2]

@kristineadennettlmC 

What you are saying would be translated into this...

=IF(H2="",H2-G2,"")

But if H2 is blank or empty, do you still want to subtract G2 from H2.

In the above IF formula H2="" is the logical condition and if it is true, H2-G2 would be evaluated else it will return a null string in the formula cell.

Tweak it as per your requirement.