+ Reply to Thread
Results 1 to 5 of 5

Nested IF to return text string based on certain conditions

  1. #1
    Registered User
    Join Date
    07-23-2017
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    28

    Nested IF to return text string based on certain conditions

    Hi Guys,

    I hope you can help, please.

    I have attached the excel file, but I will also explain.

    > The assess date and the actual date is always the first day in the month.

    > In every scenario, where the assess date is prior to the actual date, it needs to return error

    > One exception to this, is when the assess date is exactly one month prior to the actual date, it needs to return "staging"

    > Where the assess date and the actual date are equal, or the assess date always exceeds the actual date, it needs to return "subsequent"

    I have kindly received help on here previously, but I could not get the formula to work based on the fact that both assess and actual are now the first day in the month.

    Any help greatly appreciated.

    Thanks!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Nested IF to return text string based on certain conditions

    You may try this nested IF formula (see attachment)

    =IF(SUM(D4-C4)>30,"Error",IF(OR(SUM(D4-C4)=31,SUM(D4-C4)=30,SUM(D4-C4)=28,SUM(D4-C4)=29),"Staging",IF(SUM(D4-C4)<1,"Subsequent")))

    Remember to drag down to last entry
    Attached Files Attached Files

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 Version 2211, rarely 2007
    Posts
    12,843

    Re: Nested IF to return text string based on certain conditions

    Another way.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  4. #4
    Registered User
    Join Date
    07-23-2017
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    28

    Re: Nested IF to return text string based on certain conditions

    Guys! thanks so much. Much appreciated.

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 Version 2211, rarely 2007
    Posts
    12,843

    Re: Nested IF to return text string based on certain conditions

    You're welcome. Thanks for the feedback and rep.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Nested IF with dates and text return string
    By Mikeyabosbht in forum Excel General
    Replies: 19
    Last Post: 08-21-2017, 09:40 AM
  2. [SOLVED] Return a text string based on age
    By JamieWildman in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-28-2016, 12:57 AM
  3. [SOLVED] Return text string for a variety of different conditions
    By Terry-J in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-25-2014, 03:40 PM
  4. [SOLVED] Nested IF statements to FIND text string and return set values.
    By stuartm4h in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-12-2013, 12:03 PM
  5. I need a function that will return a value nested in a text string
    By dgallegos in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-18-2013, 04:06 PM
  6. Replies: 1
    Last Post: 04-08-2013, 07:07 PM
  7. Return Value Based On Partial Text String
    By JonnyBoy333 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-12-2011, 09:29 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