Fraction

[Bonniewyw]

Hi all,

Wondering if anyone could help with this?
I'm looking for formula that gives me the answer to this question:

If target achieved is 106%, commission paid is 50% with a liner progression to 100% with max target achieved of 125%. Actual achievement is 110%, what is the commission %?

106% = 50%
110% = ?%
125% = 100%

Many thanks!!
Bonnie

 

[mikerickson]

commission on X is 50 + 50*(x-106)/19

 

[Bonniewyw]

Amazing, thank a lot for your help!