+ Reply to Thread
Results 1 to 5 of 5

Nesting IF Functions

  1. #1
    Registered User
    Join Date
    11-02-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Nesting IF Functions

    I'm trying to solve the following problem and am getting close but I'm not quite there. Any insight would be much appreciated.

    What I'd like the function to do:

    if j77 equals "Yes" AND there is text in j74 AND text in J75, return "AM/PM"
    if j77 equals "Yes" AND there is text in j74 but none in j75, return text in j74
    if j77 equals "Yes" and there is no text in j74 but j75 contains text, return text in j75
    if j77 equals "Yes" but there is no text in j74 AND no text in j75, return "No Indication"
    If j77 is blank, return a blank cell instead of FALSE

    Thank you for the help!

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Nesting IF Functions

    Hi jcvanhorn and welcome to the forum,

    I believe there is a smaller limit to the number of nested if statements allowed in Excel 2003 compared to newer versions.

    See http://spreadsheetpage.com/index.php..._if_functions/ to see if it helps.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    11-02-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Nesting IF Functions

    I'm actually using 2007. Just changed my profile. Does that change things?

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

    Re: Nesting IF Functions

    How about:

    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.

  5. #5
    Registered User
    Join Date
    11-02-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Nesting IF Functions

    That works! Awesome!

    I was just using the AND function after the first IF but not the others. This works great. Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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