+ Reply to Thread
Results 1 to 4 of 4

3 logical condition if statement

Hybrid View

  1. #1
    Registered User
    Join Date
    07-19-2006
    Posts
    2

    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

  2. #2
    Danny Lewis
    Guest

    RE: 3 logical condition if statement

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


  3. #3
    Registered User
    Join Date
    07-19-2006
    Posts
    2
    I knew it was simple!!!

    Thanks a lot for helping me out

    Mike

  4. #4
    CLR
    Guest

    RE: 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(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
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1