Using two conditions in a formula

R

Richard Pitt

How do I write the following formula:

I am in cell I6

If g6 AND h6 is blank, then blank, else I5 minus g6 plus h
 
B

Bernie Deitrick

Richard,

In cell I6, enter the formula:

=IF(AND(G6="",H6=""),"",I5-G6-H6)

Though you don't check for case when G6 is blank and H6 isn't, etc.

HTH,
Bernie
MS Excel MVP
 
Top