IF Function with Multiple Criteria

[bethanon]

I have a spreadsheet containing several dates. I want to return different
text based on multiple criteria. The first criteria is comparing column I to
column J. If the dates are the same, then I'd like to return the text "NO",
and stop. If the dates are different, I then need to compare column I to
column H. and to Column D. If Column I is > H, and > D, I'd like to return
the text "YES". If Column I is > H, but < D, I'd like to return the text
"NO". The dates are all in the same row. I did have an =IF(...OR...) formula
in there that was working, because at first I was just asked to check the
second two sets of criteria. It's the addition of that criteria of the I & J
being equal, then moving on if not that is throwing me for a loop. Any
suggestions would be most appreciated.

 

[Don Guillett]

Does this help you to get started?
=if(AND(i2>h2,i2<d2),1,2)

 

[bethanon]

Thanks - I think I was making it harder than it had to be, as is usually the
case with me. I just used

=IF(OR(I14=H14,I14>D14),"NO","YES"), since the answer will always be no,
unless I & H aren't equal and will result in a later delivery than promise
date.