how do I figure multiple commission percentages

[Scott L]

What type of formula can I use to calculate a percentage range?
I want to figure a certain percentage range for a commission.

80% - 89% = 1.25% paid out
90% - 99% = 1.50% paid out

Etc..

 

[JE McGimpsey]

One way:

http://www.mcgimpsey.com/excel/variablerate.html