Feb 27 2022 07:33 AM
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")))))))
Feb 27 2022 07:43 AM
=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"})