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
What you are saying would be translated into this...
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.