Hi Hope someone can assist, looking for a calculation to give a precise value.
I have this table
<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
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>
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