% Percentage Formula for a random range

[ronie85]

Hi, I am sure this may be availabe in simple math but I need a formula for it.

Say I have a range of numebrs where 1 is the lowest and 73 is the highest, with all other numebrs in the range.
How to i streth this both ways so that 1 becomes 0% and 73 becomes 100%?
Which means 37 may be in and around 50%.

This formala will then be used for other ranges consisting of different random numbers.

 

[bebo021999]

With range of number is A1:H10
J2 is number
percentage in K2:

=(J2-1)/MAX($A$1:$H$10)