Hi,

I.m sure this is simple if you know how but i'm confused.

I have a cell that I want to return 1 of 3 values, these being
"Ongoing" "Complete" or lastly "Overdue"

Condition 1 Ongoing is returned if the date in A1 is less than the date
in A2
Condition 2 Complete is returned if there is an "x" in A3 irrespective
of the date.
Condition 3 Overdue is returned if there is no "x" in A3 and the datein
A1 is greater than the date in A2


Thanks for any help you can offer


--
Mikehughes
------------------------------------------------------------------------
Mikehughes's Profile: http://www.excelforum.com/member.php...o&userid=36528
View this thread: http://www.excelforum.com/showthread...hreadid=562805