Results 1 to 6 of 6

Excel 2010 - IF OR Statement

This is a discussion on Excel 2010 - IF OR Statement within the Excel Questions forums, part of the Question Forums category; Hello all, Need help writing and IF OR statement. In cell X3 I have an AUTOSUM that counts from 1-4 ...

  1. #1
    Board Regular Johnny Thunder's Avatar
    Join Date
    Apr 2010
    Location
    California
    Posts
    239

    Cool Excel 2010 - IF OR Statement

    Hello all,


    Need help writing and IF OR statement.

    In cell X3 I have an AUTOSUM that counts from 1-4 and I need cell Y3 to relay a comment based on what cell X3 returns,

    If 1="Received"
    If 2="In Progress"
    If 3="Testing"
    If 4="Completed"
    If blank="Awaiting"

    Any help is appreciated. Thanks

  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,200

    Default Re: Excel 2010 - IF OR Statement

    Something like,

    =IF(X3="","waiting",LOOKUP(X3,{1,2,3,4},{"a","b","c","d"}))

  3. #3
    Board Regular kevinb11's Avatar
    Join Date
    Feb 2012
    Location
    Bucyrus, OH
    Posts
    332

    Default Re: Excel 2010 - IF OR Statement

    Quote Originally Posted by Johnny Thunder View Post
    Hello all,


    Need help writing and IF OR statement.

    In cell X3 I have an AUTOSUM that counts from 1-4 and I need cell Y3 to relay a comment based on what cell X3 returns,

    If 1="Received"
    If 2="In Progress"
    If 3="Testing"
    If 4="Completed"
    If blank="Awaiting"

    Any help is appreciated. Thanks
    Enter the below formula in Y3

    =IF(X3=1,"Received",IF(X3=2,"In Progress",IF(X3=3,"Testing",IF(X3=4,"Completed","Awaiting"))))

  4. #4
    Board Regular Weazel's Avatar
    Join Date
    Dec 2011
    Location
    Florida
    Posts
    1,474

    Default Re: Excel 2010 - IF OR Statement

    Well, figured since I typed it I'd post it though Brian was a bit faster


    =IF(X3="","Awaiting",LOOKUP(X3,{1,2,3,4},{"Received","In Progress","Testing","Completed"}))

  5. #5
    Board Regular
    Join Date
    Jul 2009
    Location
    Woking UK
    Posts
    1,872

    Default Re: Excel 2010 - IF OR Statement

    Hi

    Try :-
    Code:
    =IFERROR(CHOOSE($X3,"Received","In Progress","Testing","Completed"),"Awaiting")
    hth
    Mike

    -----------------------------------------------
    Some solutions don't require an IF!

    When posting code wrap your code between [CODE] tags.

    Paste your Excel data...

    MrExcel HTML Maker or Excel Jeanie

  6. #6
    Board Regular Johnny Thunder's Avatar
    Join Date
    Apr 2010
    Location
    California
    Posts
    239

    Default Re: Excel 2010 - IF OR Statement

    All worked perfectly!!! Thanks!

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com