Hi all, I'm new to the forum and I'm thankful for it as it is a great source of knowledge.
Here's my dilemma:
I am in need of a formula that will figure out a multiplier number from a range of numbers. Here's the example I'm working with. This will be used in a worksheet to measure performance and incentive pay for my group and below is a sample of one of the many goals for the group. Incentive will be calculated on a point system. The multiplier is based on the "Actual Result" or performance of the individual. With that said, if the value falls between a range within say, the threshold rate of 1.75% and the target rate of 1.25%, what formula can assist in figuring out the actual multiplier?
<tbody>
</tbody>
Any assistance is greatly appreciated!
Thank you!
Here's my dilemma:
I am in need of a formula that will figure out a multiplier number from a range of numbers. Here's the example I'm working with. This will be used in a worksheet to measure performance and incentive pay for my group and below is a sample of one of the many goals for the group. Incentive will be calculated on a point system. The multiplier is based on the "Actual Result" or performance of the individual. With that said, if the value falls between a range within say, the threshold rate of 1.75% and the target rate of 1.25%, what formula can assist in figuring out the actual multiplier?
Available Points | (Multiplier) | Targets | ACTUAL RESULT | POINTS EARNED | ||||
15 | 50% | Threshold | 1.75% | 1.36% | =Multiplier X Available Points | |||
100% | Target | 1.25% | Multiplier | |||||
200% | Maximum | 0.75% |
<tbody>
</tbody>
Any assistance is greatly appreciated!
Thank you!