Having difficulty with something that should be so easy.
I need a formula for:
for cell C2 =IF A2 is not blank AND A2 + B2 is not blank then C1+A2-B2, else 0
(any values in A2 and B2 might be a positive or a negative number)
I have looked at Excel help and used the formula
IF(AND A2 <> " ", B2 <> " ", C1+A2-B2, 0) and it returns wrong result.
My mind just can't get aorund this simple issue today.
Thanks for any help!
Bookmarks