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

Try

=if(A3="x","Complete",if(A1<A2,"Ongoing",if(A1>A2,"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
>
>

I knew it was simple!!!

Thanks a lot for helping me out

Mike

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" 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
>
>