Hello,

I have a commission structure to determine based on a rating scale. Someone input correct (I think) formulas but I need to actually understand the what and why so I can adapt it to a new scale. I have 2 examples from last year. Any help is extremely appreciated.

Ex 1: Rating given of 2.8 (highest possibility 4). Dollar amount possible $1,313- actual payout for the 2.8 rating was $1,247. The formula and some other information is below

Formula: =((L92-2)/1)*($F$9-$F$10)+$F$10

L92: Rating given by manager to represent that month's performance (In this example the value is 2.8)

Rating Scale
F8: 130% (payout percentage given for performance of 4)
F9: 100% (payout percentage given for performance of 4)
F10: 70% (payout percentage given for performance of 4)
F11: 0% (payout percentage given for performance of 4)