+ Reply to Thread
Results 1 to 5 of 5

Help with Nested IF Formula Needed

  1. #1
    Registered User
    Join Date
    06-11-2013
    Location
    NYC
    MS-Off Ver
    Excel 2007
    Posts
    42

    Help with Nested IF Formula Needed

    Hi there,

    I have an Excel spreadsheet in which I'm trying to add a column that will populate one of four values based on data elsewhere in the sheet. Here's a list of the values I would need to populate and data elsewhere in the sheet that would need to be present in order for each value to appear:

    (1) Official Launch: Cell A1 is blank and the string of text in Cell B1 contains the phrase "sec.gov"

    (2) Launch: Cell A1 is blank and the string of text in Cell B1 does not contain the phrase "sec.gov"

    (3) Official Close: Cell A1 has a value, and the text in Cell B1 contains the phrase "sec.gov"

    (4) Close: Cell A1 has a value, and the text in Cell B1 does not contain the phrase "sec.gov"


    I can attach an example sheet with some of the values in columns A and B in my sheet if this would be helpful.

    Any idea on how to do this or if it's even possible?

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

    Re: Help with Nested IF Formula Needed

    take a look at this.
    Attached Files Attached Files
    Last edited by popipipo; 04-02-2014 at 04:28 PM.
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Help with Nested IF Formula Needed

    Try

    =IF(COUNTIF(B1,"*sec.gov*"),"Official ","")&IF(A1="","Launch","Close")
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Registered User
    Join Date
    06-11-2013
    Location
    NYC
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: Help with Nested IF Formula Needed

    I'm not seeing an attachment to that first reply if there is one. Am I missing something?

    For the second solution, testing that formula and it seems to be getting me partway there, but it isn't outputting all of the four items I'm looking for.

  5. #5
    Registered User
    Join Date
    06-11-2013
    Location
    NYC
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: Help with Nested IF Formula Needed

    Popipipo - the first formula in that spreadsheet you attached works perfectly! Thanks for the help!

+ 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 or IF(AND formula needed please
    By rwalker1052 in forum Excel General
    Replies: 3
    Last Post: 11-26-2013, 03:58 AM
  2. Nested VLookup, Match Formula Help Needed
    By jealkon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-08-2013, 02:18 PM
  3. [SOLVED] Nested Formula - Additional Help needed
    By jealkon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-28-2012, 02:56 PM
  4. Nested If Formula Help Needed
    By johnsor1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-26-2012, 09:34 AM
  5. Nested IF or LOOKUP Formula needed?
    By shudder in forum Excel General
    Replies: 6
    Last Post: 09-14-2009, 11:12 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