+ Reply to Thread
Results 1 to 4 of 4

Nested IF Statements

  1. #1
    Registered User
    Join Date
    09-19-2017
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2

    Nested IF Statements

    I am getting stuck having multiple IF statements work for me. I'm not sure if nesting them or having a Macro would be better.

    I would like to have a cell in one column read off another cell in another column, and depending on the criteria in that determining column, provide a date that would be 1, 3, or 5 years added to the date and be placed in another cell.

    For example from the attached spreadsheet:
    If the impact score (column C) is low, moderate, or high, I would like the next assessment (column B) to have added a yearly date of (1 for high, 3 for moderate, and 5 for low) and placed in the next assessment date(column B). I did this with just a low impact score on row 2, but I would like to have all this performed for the moderate and high impacts as well, and I am getting stuck on nesting the statements.

    The statement I have is the following:
    =IF(C4="HIGH",DATE(YEAR(A4)+1,MONTH(A4),DAY(A4), IF(C4="MODERATE",DATE(YEAR(A4)+3,MONTH(A4),DAY(A4), IF(C4="LOW",DATE(YEAR(A4)+1,MONTH(A4),DAY(A4)))))))
    Attached Files Attached Files

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Nested IF Statements

    How about this:

    Please Login or Register  to view this content.
    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: Nested IF Statements

    Please Login or Register  to view this content.
    The brackets are not in the right place
    Try this
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  4. #4
    Registered User
    Join Date
    09-19-2017
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2

    Re: Nested IF Statements

    That worked!!! Thank you so much popipipo!!!!!!

+ 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. questions with if statements and nested if statements
    By Pat Excel in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-03-2013, 01:41 PM
  3. Nested if statements with AND and OR statements
    By joeljoel in forum Excel General
    Replies: 4
    Last Post: 08-08-2011, 12:57 PM
  4. Multiple nested IF statements and AND statements
    By TonyGetz in forum Excel General
    Replies: 2
    Last Post: 12-14-2010, 03:07 AM
  5. Nested If statements / logic statements
    By Brainless_09 in forum Excel General
    Replies: 3
    Last Post: 06-17-2009, 02:59 PM
  6. Replies: 12
    Last Post: 05-15-2009, 08:38 AM
  7. [SOLVED] nested if statements
    By steve in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-28-2005, 02:06 PM

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