Tiered Payout Schedule, based on number or units sold

First off, let me say thanks for taking the time to even read this!

What I am trying to do is set up a pay tier based on the number of memberships sold

1-9 memberships sold pays $7.50
10-19 Memberships sold pays $9.50
20-29 Memberships sold pays $11.50
30-39 Memberships sold pays $13.50
40-49 Memberships sold pays $15.50
50-infinity memberships sold pays $18.00

I have attached a copy of the worksheet I am trying to make, and just not sure what formula would work best.

Want the formula to look at a specific cell and decide what pay tier it falls into, and do the appropriate multiplication.

Would appreciate any help that can be provided!

Try:

Please Login or Register  to view this content.