+ Reply to Thread
Results 1 to 3 of 3

Multiple If Statements

  1. #1
    Registered User
    Join Date
    10-11-2015
    Location
    Wpg, MB
    MS-Off Ver
    Excel 2010
    Posts
    34

    Multiple If Statements

    Hello All,

    I am trying to modify an existing If Statement that works. However, I now need it to include an additional column

    =IF(AND(NOT(M10=""),(NOT(M10="SUPERSEEDED"))),"REVIEWED",IF(M10="SUPERSEEDED","SUPERSEEDED",IF(F10="","WAITING ON SUB-TRADE",IF(H10>=TODAY(),"WAITING ON CONSULTANT - ON TIME",IF(H10<TODAY(),"WAITING ON CONSULTANT - OVERDUE","ERROR")))))

    I need to add one more if statement that says IF(H10 <TODAY() and L10<TODAY(),”Revise And Resubmit” however, when I add this section it only returns the results for H10<Today. Help.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: Multiple If Statements

    Try it like this:

    =IF(AND(M10<>"",M10<>"SUPERSEEDED"),"REVIEWED",IF(M10="SUPERSEEDED","SUPERSEEDED",IF(F10="","WAITING ON SUB-TRADE",IF(H10>=TODAY(),"WAITING ON CONSULTANT - ON TIME",IF(L10<TODAY(),"Revise and Resubmit","WAITING ON CONSULTANT - OVERDUE")))))

    Note that you don't need to test explicitly for H10<TODAY() as you have already tested for H10>=TODAY(). Also, I'm not sure how the "ERROR" message would be triggered in your formula.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    10-11-2015
    Location
    Wpg, MB
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Multiple If Statements

    Hi Pete,

    It partially worked. It returned the Revise and Resubmit however, now it does not return the Waiting on Consultant - Overdue. Thoughts?

    RBK2

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Nested if statements containing multiple and statements
    By John M. in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-22-2014, 11:48 PM
  2. Formula with multiple IF statements and IF AND statements
    By lottidotti in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-14-2013, 08:03 AM
  3. Replies: 3
    Last Post: 07-25-2013, 08:25 AM
  4. [SOLVED] Formula Problem with Multiple IF / AND Statements and Multiple outcome?
    By JONBOY666 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-22-2013, 01:32 PM
  5. [SOLVED] Syntax for formula that uses multiple conditions inside of multiple IF statements
    By njmiller31 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-02-2013, 11:55 AM
  6. Multiple nested IF statements and AND statements
    By TonyGetz in forum Excel General
    Replies: 2
    Last Post: 12-14-2010, 03:07 AM
  7. Replies: 12
    Last Post: 05-15-2009, 08:38 AM

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