I have a series of numbers between 5 and 10. I want to plot them on a new scale from 65-100 (yes a grade). I'm doing this in excel. Can someone help me with a formula?

Here's roughly how things should work out but I'd like a formula to automate it as there are going to be decimals involved.

10 = 100

9 = 93

8 = 86

7 = 79

6 = 72

5= 65

Thanks!

## Bookmarks