Forum Discussion
Formula Error
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<24999...
=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!
