I need to create a formula for a tier pay system

[guy0nthec0uch]

Hey guys, I really try not to bother you all but this one is driving me nuts.

I work at a car dealership and I'm tasked with paying our BDC reps based on the units they sell.

So, I've factored a spreadsheet to calculate each of their sold but I need to pay them based on the following parameters.

15 SOLD = 250
20 SOLD = 350
25 SOLD = 500
30 SOLD = 750
35 SOLD = 1000

So, I need a formula that can take the cell used to calculate the sold and base the commission on the total.

I need this total to reflect under the DEALER SPIFF for each. Ideas?

 

[Dave Patton]

Does the formula relate to the first post? I do not see a 450.