Convert value to a weight score

[rz6657]

Using a formula, how to convert the Score the relevant Weighted Score as shown below. Thx



Score Weighted Score
0 0
1 1
2 0.9
3 0.8
4 0.7
5 0.6
6 0.5
7 0.4
8 0.3
9 0.2
10 0.1

[MrShorty]

I expect one of Excel's lookup functions will be part of the solution. VLOOKUP() seems to be where most people start learning about Excel's lookup functions: https://support.office.com/en-us/art...8-93a18ad188a1

=VLOOKUP(score,lookuptable,2)

[José Augusto]

Or

Please Login or Register  to view this content.