## Problem calculating something in Excel  Tags:
Data analysis
Data Mining
Development
Microsoft Windows
The production goal for a quarter is 1.474 now if they meet that goal they get 100% of the bonus but if their number is 1.54844 then they get 180% of the bonus and if their number is 1.43036 they only get 50% of the bonus. so if their number is 1.52 they should get approx. 170 % of the bonus. 1.54844 is 105% of 1.4747 and 1.43036 is 97% of 1.4747. My problem is figuring out the bonus when they fall in the middle some were. The most bonus you can get is 180% and the lowest bonus is 50% Any Help would be apriciated

Thanks. We'll let you know when a new response is added.

Try the formula in this file. You can test by entering the actual production. This assumes linear increase or decrease based on the numbers you gave. It is assumed that bonus is zero if production is lower than the minimum you gave.
Oops it seems I cannot attach a file, I will send a personal mail

## Discuss This Question: 2 Replies 