Fit scores
The following formula will do this:
=(A1-32)*40/85 + 60
assuming your actual score is in A1.
Hope this helps.
Pete
Sciguy wrote:
I'm trying to 'fit' scores into a range between 60% and 100%; actual scores
range from 32% to 117%. Does anyone have suggestions on how to approach this?
|