+ Reply to Thread
Results 1 to 3 of 3

Multiple If Statements Causing "FALSE" in Results

  1. #1
    Registered User
    Join Date
    05-22-2013
    Location
    NYC
    MS-Off Ver
    Excel 2010
    Posts
    1

    Multiple If Statements Causing "FALSE" in Results

    I am using the formula shown below (file attached). Everything works fine but I get "FALSE" showing up when I add another “& IF” statement. For example, a result might be "FALSEInsurance". I just want this to read "Insurance". How can I get rid of the “FALSE”? The first IF statement works fine. It is just when I add “& IF” (to get around nesting limit) that I start getting “FALSE” in the results.

    =IF(ISNUMBER(SEARCH("Delta",C17)),Deductions!$B$5,IF(ISNUMBER(SEARCH("ResidenceInns",C17)),Deductions!$B$11,IF(ISNUMBER(SEARCH("Shell",C17)),Deductions!$B$23,IF(ISNUMBER(SEARCH("Exxon",C17)),Deductions!$B$23,IF(ISNUMBER(SEARCH("Racetrac",C17)),Deductions!$B$23,IF(ISNUMBER(SEARCH("FuelZone",C17)),Deductions!$B$23))))))&IF(ISNUMBER(SEARCH("Subway",C17)),Deductions!$B$24,IF(ISNUMBER(SEARCH("Chipotle",C17)),Deductions!$B$24,IF(ISNUMBER(SEARCH("TacoBell",C17)),Deductions!$B$24,IF(ISNUMBER(SEARCH("Carefirst",C17)),Deductions!$B$12,IF(ISNUMBER(SEARCH("VZWRLSS",C17)),Deductions!$B$7,IF(ISNUMBER(SEARCH("Hertz",C17)),Deductions!$B$21,))))))&IF(ISNUMBER(SEARCH("Amazon",C17)),Deductions!$B$16,IF(ISNUMBER(SEARCH("Theater",C17)),Deductions!$B$10,IF(ISNUMBER(SEARCH("Marriott",C17)),Deductions!$B$11,IF(ISNUMBER(SEARCH("Walgreens",C17)),Deductions!$B$16,IF(ISNUMBER(SEARCH("Quiznos",C17)),Deductions!$B$24,IF(ISNUMBER(SEARCH("American",C17)),Deductions!$B$5,))))))
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: Multiple If Statements Causing "FALSE" in Results

    Hi NYC...

    I remember there were a limit of 7 nested IFs in the past... maybe Excel 2010 overlooks this now... anyway, figured to give my two cents...

  3. #3
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Multiple If Statements Causing "FALSE" in Results

    I believe there is a number of characters max also....
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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