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


--
themax16
------------------------------------------------------------------------
themax16's Profile: http://www.excelforum.com/member.php...o&userid=23622
View this thread: http://www.excelforum.com/showthread...hreadid=480068

Hi James,

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

Mike

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(A1A2,OR(A3="on hold",A3="open")),"failed","ok")

Mike

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(A1A2,OR(A3="on hold",A3="open")),"failed","ok")

Mike :)


--
Grandslam90
------------------------------------------------------------------------
Grandslam90's Profile: http://www.excelforum.com/member.php...o&userid=17408
View this thread: http://www.excelforum.com/showthread...hreadid=480068

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


--
themax16
------------------------------------------------------------------------
themax16's Profile: http://www.excelforum.com/member.php...o&userid=23622
View this thread: http://www.excelforum.com/showthread...hreadid=480068