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