Thread: Fit scores
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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?