Forum Discussion
Solved
Attempting a Multi-IF Function | Help On Last String
=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)
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.
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.
- Thank you!
