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