Multiple Criteria

[themax16]

Morning/Afternoon everyone,
I am trying to set up a conditional formula..

I have a date in cell A1 and another in Cell A2. Cell A3 is populated
with either 'complete, on hold or open'

I would like cell A4 to read 'ok' if the date in A1 is less then or
equal to date in A2. and A3 can read either 'complete, on hold or
open'

But
'
If cell the date in A1 in more then date in A2 and A3 = 'on hold or
open' it should read 'Failed' in A4.

Can anyone help??

James

 

[Guest]

Hi James,

What do you want to show in A4 if the date in A1 is greater than A2 and A3 =
"complete" ?

Mike

 

[Guest]

That said assuming that when the date in A1 is greater than A2 and A3 =
"complete" is also ok then this formula should work for you.

=IF(AND(A1>A2,OR(A3="on hold",A3="open")),"failed","ok")

Mike

 

[Grandslam90]

assuming that when the date in A1 is greater than A2 and A3 =
"complete" is also ok then this formula should work for you.

=IF(AND(A1>A2,OR(A3="on hold",A3="open")),"failed","ok")

Mike

 

[themax16]

thanks mike..
this seems to work just as it should!
your a great help
james