=If Multiple Criteria

B

bethanon

Wondering how to nest this? I have an =IF(OR....) right now that works, but
I've just had another criteria thrown at me. How can I get Excel to answer
for me: If the values in I & J are the same, enter the text "NO", and stop
searching. If they are not the same, however, check to see that I is greater
than J, and if so, also check to see if I is greater than D, and if so, the
answer is the text "YES", and if those criteria are not met, then the answer
remains "NO". Previously it just checked the second half of that, which I was
doing via =IF(OR(I7>J7,I7>D7),"YES", "NO").
 
S

ShaneDevenshire

Hi,

I believe you can simplify this to

=IF(AND(I7>J7,I7>D7),"Yes","No")

The only time the answer is yes is when I is greater than J and greater than
D.

If this helps, please check Yes.
 

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

Countif with two criteria 2
IF Statement 1
The "IF" Statement 1
IF Function with Multiple Criteria 2
Custom Validation formula for business rules 3
Help with a basic condition 0
A staying on schedule formula: 2
If condition to find Target 1

Top