Sliding Scale

I was hoping for some help creating a sliding scale. I have looked around a bit, but could not find anything like this, they all seem to be tax bracket or commission examples. We are given a score and have to match that score to a percent increase based on a lower limit and upper limit. What is the best way to create this in Excel?

Example:
received score of 6.75 what is the percent increase?

The minimum score is a 4.5 which is given 2% and maximum score is 6.99 which is given 3%.

I think on a sliding scale they should receive somewhere around 2.78%, but we have to do hundreds of them. What is the best way to calculate this in excel? TY

Originally Posted by shg

Row\Col	A	B	C
1	4.50	2.00%	B1: =2% + (A1 - 4.5) / (6.99 - 4.5) * (3% - 2%)
2	5.00	2.20%
3	4.70	2.08%
4	6.75	2.90%
5	6.99	3.00%

This worked perfect, thanks