Formula for figuring a multiplier in a range

[Doc_H]

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?


[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]Available
Points[/TD]
[TD][/TD]
[TD](Multiplier)[/TD]
[TD]Targets[/TD]
[TD][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ACTUAL RESULT[/TD]
[TD="align: center"][/TD]
[TD="align: center"]POINTS
EARNED[/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD][/TD]
[TD="align: center"]50%[/TD]
[TD="align: center"]Threshold[/TD]
[TD="align: center"]1.75%[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1.36%[/TD]
[TD="align: center"][/TD]
[TD="align: center"]=Multiplier X Available Points[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]100%[/TD]
[TD="align: center"]Target[/TD]
[TD="align: center"]1.25%[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Multiplier[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]200%[/TD]
[TD]Maximum[/TD]
[TD]0.75%[/TD]
[TD][/TD]
[TD="align: center"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Any assistance is greatly appreciated!

Thank you!

 

[Doc_H]

That worked great, shg. Thanks for the input, all.