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.

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"bethanon" wrote in message
...
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.

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,I14D14),"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.



"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"bethanon" wrote in message
...
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.