Multiple Criteria

T

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
 
M

Mike S

Hi James,

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

Mike
 
M

Mike S

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
 
G

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 :)
 
Top