theronager,
Welcome to the forum!
Attached is an example workbook based on the criteria you described.
In column A is the list of data you provided in your original post starting in A2.
In column B is the adjusted score which is derived using this formula in B2 and copied down:
=IF(A2=$K$4,$L$4,FORECAST(A2,IF(A2<$K$4,$L$3:$L$4,$L$4:$L$5),IF(A2<$K$4,$K$3:$K$4,$K$4:$K$5)))
That formula uses the Reference Table located in K3:L5.
K3 shows the minimum value listed in the Original Score list:
L3 shows the desired adjusted score for the minimum value, which is 0 based on your original post.
K4 shows the average value listed in the Original Score list:
L4 shows the desired adjusted score for the average value, which is 50 based on your original post.
K5 shows the maximum value listed in the Original Score list:
L5 shows the desired adjusted score for the maximum value, which is 100 based on your original post.
With that table of information, the formula in column B shows the adjusted score accurately for each entry in column A. Is something like that what you're looking for?
Bookmarks