Attempting a Multi-IF Function | Help On Last String

[CamReid]

=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 · Accepted solution]

@CamReid 

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

=MIN(VLOOKUP(H21,$J$1:$K$6,2)+MAX(H21-4000,0)*0.03,799.99)

This an be filled down.

[#3]

Thank you!