Formula Error

Copper 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!