Calculating values between two numbers

**aphipps** · 07-18-2011, 07:57 PM

I am trying to assign a point value to a measurement between a minimum and maximum tolerance range.

Minimum range is 2 with a point value of 10.

Maximum range is 6 with a point value of 2.

My measurement is 3.23 and I need to calculate its point value.

I need a formula that is able to reference different tolerance values and different point values.

**6StringJazzer** · 07-18-2011, 10:37 PM

Welcome to the Forum!

Very important point: Is your point scale linear? If so then you can do this. For readability set up the following named ranges (below, the word "range" refers to a range of numbers, not an Excel range):

RangeMin: the lowest value in the range
PointMin: the points for the lowest value
RangeMax: the highest value in the range
PointMax: the points for the highest value

Then to calculate points for a measurement in A1:

=PointMin+(PointMax-PointMin)*(A1-RangeMin)/(RangeMax-RangeMin)

If your point scale is nonlinear then you need to describe how it works.