Pay Out increasing % Calculation

[Barbados]

Hi Hope someone can assist, looking for a calculation to give a precise value.
I have this table

COL A	COL B	COL C	COL D
Sales	Target	Achievement %	Pay Out %
110	100	110.0000%	100%
150	200	75.0000%	0%
300	300	100.0000%	100%
391.58	400	97.8950%	?
495.687	500	99.1374%	?
440	450	97.7778%	?
118	123	95.9350%	?
111	115	96.5217%	?

<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>
</tbody>

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