Pay Out increasing % Calculation

Barbados

New Member
Joined
Mar 14, 2019
Messages
4
Hi Hope someone can assist, looking for a calculation to give a precise value.
I have this table
COL A
COL BCOL CCOL D
SalesTargetAchievement %Pay Out %
110100110.0000%100%
15020075.0000%0%
300300100.0000%100%
391.5840097.8950% ?
495.68750099.1374% ?
44045097.7778% ?
11812395.9350% ?
11111596.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:)
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Watch MrExcel Video

Forum statistics

Threads
1,108,612
Messages
5,523,891
Members
409,542
Latest member
Shezz01

This Week's Hot Topics

Top