Quote:
Originally Posted by capt.kash
I figured it Out.....=IF(AND(ISBLANK(A2),ISBLANK(B2)),"",C1+A2-B2)
|
If you're going to use the
AND function, remember that both statements should be
TRUE or else it would return
FALSE.
The
AND operand function works like
MULTIPLICATION.
I suggest you use the OR function.
=IF(OR(ISBLANK(A2),ISBLANK(B2)),"",C1+A2-B2)
The
OR operand function works like
ADDITION.