Formula Error

%3CLINGO-SUB%20id%3D%22lingo-sub-3218292%22%20slang%3D%22en-US%22%3EFormula%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3218292%22%20slang%3D%22en-US%22%3E%3CP%3EI%20can't%20figure%20out%20why%20i'm%20getting%20a%20%22false%22%20result%20with%20this%20formula%20when%20I5%20%3D%20%24103%2C000%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(AND(I5%26lt%3B49999%2C%224%20-%20Email%20Marketing%22)%2C(IF(AND(I5%26gt%3B49999%2CI5%26lt%3B99999%2C%223%20-%20Annual%22)%2C(IF(AND(I5%26gt%3B100000%2CI5%26lt%3B249999%2C%222%20-%20Semi-Annual%22)%2C(IF(AND(I5%26gt%3B249999%2CI5%26lt%3B31000000%2C%221%20-%20Quarterly%22)%2C%22Other%22)))))))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3218292%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3218327%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3218327%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1318668%22%20target%3D%22_blank%22%3E%40SHamburg14%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(I5%26lt%3B49999%2C%20%224%20-%20Email%20Marketing%22%2C%20IF(I5%26lt%3B99999%2C%20%223%20-%20Annual%22%2C%20IF(I5%26lt%3B249999%2C%20%222%20-%20Semi-Annual%22%2C%20IF(I5%26lt%3B31000000%2C%20%221%20-%20Quarterly%22%2C%20%22Other%22))))%3C%2FP%3E%0A%3CP%3EOr%3C%2FP%3E%0A%3CP%3E%3DLOOKUP(I5%2C%20%7B0%2C%2050000%2C%20100000%2C%20250000%2C%203100000%7D%2C%20%7B%224%20-%20Email%20Marketing%22%2C%20%223%20-%20Annual%22%2C%20%222%20-%20Semi-Annual%22%2C%20%221%20-%20Quarterly%22%2C%20%22Other%22%7D)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3221622%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3221622%22%20slang%3D%22en-US%22%3EThanks%20so%20much!%3C%2FLINGO-BODY%3E
New Contributor

I can't figure out why i'm getting a "false" result with this formula when I5 = $103,000

 

=IF(AND(I5<49999,"4 - Email Marketing"),(IF(AND(I5>49999,I5<99999,"3 - Annual"),(IF(AND(I5>100000,I5<249999,"2 - Semi-Annual"),(IF(AND(I5>249999,I5<31000000,"1 - Quarterly"),"Other")))))))

2 Replies

@SHamburg14 

 

=IF(I5<49999, "4 - Email Marketing", IF(I5<99999, "3 - Annual", IF(I5<249999, "2 - Semi-Annual", IF(I5<31000000, "1 - Quarterly", "Other"))))

Or

=LOOKUP(I5, {0, 50000, 100000, 250000, 3100000}, {"4 - Email Marketing", "3 - Annual", "2 - Semi-Annual", "1 - Quarterly", "Other"})

Thanks so much!