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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula using "if cell is blank" 4
Is a Nested Formula what I need? 1
Function Error? 3
Cell Required before Closing 1
Formula not being Friendly 3
Conditional Formatting 2
IF Statements 1
problem with formulas (2) 7

Top