Attempting a Multi-IF Function | Help On Last String

Copper Contributor

=IF(H21<101,$7.99/month,IF(H21<201,$14.99/month,IF(H21<501,$29.99/month,IF(H21<1001,$54.99/month,IF(H21<2001,$99.99/month,IF(H21<4001,$149.99/month,$149.99+$0.03 for each additional 1 to a max of 799.99)

2 Replies
best response confirmed by CamReid (Copper Contributor)


I'd create a small lookup range. In the screenshot below, it is in J1:K6, but it can be anywhere, even on another sheet.


The formula for row 21 is




This an be filled down.