# Multiple If Statements Causing "FALSE" in Results

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,))))))

2. ## 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. ## Re: Multiple If Statements Causing "FALSE" in Results

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

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

#### 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