# Pay Out increasing % Calculation

##### New Member
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

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

#### steve the fish

##### Well-known Member
Hi. Try this:

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

##### New Member
Brilliant! Works great - Thanks

Replies
5
Views
305
Replies
4
Views
419
Replies
1
Views
498
Replies
2
Views
319
Replies
3
Views
313

1,129,880
Messages
5,638,810
Members
417,054
Latest member
elimiro

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back