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!
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!