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(I7J7,I7D7),"YES", "NO").

=IF(I7=J7,"NO",IF(OR(I7J7,I7D7),"YES", "NO"))
--
David Biddulph

"bethanon" wrote in message
...
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(I7J7,I7D7),"YES", "NO").

Hi,

I believe you can simplify this to

=IF(AND(I7J7,I7D7),"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.
--
Thanks,
Shane Devenshire


"bethanon" wrote:

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(I7J7,I7D7),"YES", "NO").