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