3 logical condition if statement
 

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

3 logical condition if statement
 

Try

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

"Mikehughes" wrote:


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

3 logical condition if statement
 

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( A1A2,"Overdue",""))))

Vaya con Dios,
Chuck, CABGx3




"Mikehughes" wrote:


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

3 logical condition if statement
 

I knew it was simple!!!

Thanks a lot for helping me out

Mike


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