SOLVED

# Attempting a Multi-IF Function | Help On Last String

Copper Contributor

# 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)

2 Replies
best response confirmed by CamReid (Copper Contributor)
Solution

# Re: Attempting a Multi-IF Function | Help On Last String

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.

# Re: Attempting a Multi-IF Function | Help On Last String

Thank you!
1 best response

Accepted Solutions
best response confirmed by CamReid (Copper Contributor)
Solution

# Re: Attempting a Multi-IF Function | Help On Last String

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.