Using two conditions in a formula

  • Thread starter Thread starter Richard Pitt
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

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
Formula with criteria of blank cell 1
problem with formulas (2) 7
Is there an Excel Function that can be used in lieu of this formul 5
Tighter formula than this? 5
IF Statements 1
How to setup formula to collect ongoing information 1
Is a Nested Formula what I need? 1

Back
Top