Pay Out increasing % Calculation

[Barbados]

Hi Hope someone can assist, looking for a calculation to give a precise value.
I have this table
[TABLE="class: grid, width: 300"]
<colgroup><col style="mso-width-source:userset;mso-width-alt:2779; width:57pt" width="76" span="2"> <col style="mso-width-source:userset;mso-width-alt:4534;width:93pt" width="124"> <col style="mso-width-source:userset;mso-width-alt:2889;width:59pt" width="79"> </colgroup><tbody>[TR]
[TD="width: 76"]COL A
[/TD]
[TD="width: 76"]COL B[/TD]
[TD="width: 124"]COL C[/TD]
[TD="width: 79"]COL D[/TD]
[/TR]
[TR]
[TD]Sales[/TD]
[TD]Target[/TD]
[TD]Achievement %[/TD]
[TD]Pay Out %[/TD]
[/TR]
[TR]
[TD]110[/TD]
[TD]100[/TD]
[TD]110.0000%[/TD]
[TD="align: right"]100%[/TD]
[/TR]
[TR]
[TD]150[/TD]
[TD]200[/TD]
[TD]75.0000%[/TD]
[TD="align: right"]0%[/TD]
[/TR]
[TR]
[TD]300[/TD]
[TD]300[/TD]
[TD]100.0000%[/TD]
[TD="align: right"]100%[/TD]
[/TR]
[TR]
[TD]391.58[/TD]
[TD]400[/TD]
[TD]97.8950%[/TD]
[TD] ?
[/TD]
[/TR]
[TR]
[TD]495.687[/TD]
[TD]500[/TD]
[TD]99.1374%[/TD]
[TD] ?
[/TD]
[/TR]
[TR]
[TD]440[/TD]
[TD]450[/TD]
[TD]97.7778%[/TD]
[TD] ?
[/TD]
[/TR]
[TR]
[TD]118[/TD]
[TD]123[/TD]
[TD]95.9350%[/TD]
[TD] ?
[/TD]
[/TR]
[TR]
[TD]111[/TD]
[TD]115[/TD]
[TD]96.5217%[/TD]
[TD] ?
[/TD]
[/TR]
</tbody>[/TABLE]
And need to calculate the pay out % of a bonus with these limits.
Achievement of <=95.00% = 0% Payout.
Achievement of >=100.00% = 100% Payout.
Achievement of between 95% and 100% receives an increasing amount.
So for example at 95.1% pay out % would be precisely 2%, but what would the pay out % be if they achieved 95.177%
Thanks for any assistance

 

[steve the fish]

Hi. Try this:

=MAX(MIN(C2,100%)-95%,0)/5%

 

[Barbados]

Brilliant! Works great - Thanks