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