3 logical condition if statement

[Mikehughes]

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 bein
"Ongoing" "Complete" or lastly "Overdue"

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


Thanks for any help you can offe

 

[Guest]

Try

=if(A3="x","Complete",if(A1<A2,"Ongoing",if(A1>A2,"Overdue","")))

 

[Guest]

Here's one that will also check for TEXT values in A1 and A2......

=IF(OR(ISTEXT(A1),ISTEXT(A2)),"Improper
value",IF(A3="x","Complete",IF(A1<A2,"Ongoing",IF(A1>A2,"Overdue",""))))

Vaya con Dios,
Chuck, CABGx3

 

[Mikehughes]

I knew it was simple!!!

Thanks a lot for helping me out

Mik