Say I have a range: 50 through 90, therefore the mean value is 70.
I would like a formula to return the percentage from a given value within that range, based on how close it is to this (middle) value.
50 would return 0%
60 would return 50%
70 would return 100%
80 would return 50%
90 would return 0%
I'm trying to find a formula that could take these parameters to return such a percentage.
Thank you in advance for any help provided :)