# 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

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

#### 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
297
Replies
4
Views
410
Replies
1
Views
488
Replies
2
Views
314
Replies
3
Views
307

1,127,560
Messages
5,625,506
Members
416,115
Latest member
Gonzo5711

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