# Creating a Scaled Grade Sheet

Hi, I know what I want to do, but I'm not sure which function I'm supposed to use, if any at all.

I'm making a grade sheet for my students for a standardized test. On this test, getting 35 answers correct (GRADE) is a score of 120 (SCORE). Getting 34 correct is 117, getting 33 is 113 and so on and so forth. I want to be able to input my students' GRADEs into a cell and have it return the corresponding scaled SCORE. This can be in the same cell or in an adjacent cell. How do I do this? Thank you in advance for your help!

PS - Unfortunately, for some portions of the test, the scale is not constant. For example, in the illustration above, getting 35 answers correct is a score of 120, which is a scale of 3.429. Getting 34 answers correct is a score of 117, which is a scale of 3.441. Thus, I know I may need to manually type in the scale (since I did not devise the scale myself) and have the GRADE values be "replaced" or "re-represented" by the SCORE values, but I'm not sure how. Do the REPLACE/SUBSTITUTE functions come into play at all?

### You could try this simple formula

=A1*120/35

paste the above formula in cell B1, then any grade you enter in A1 will show as scaled grade in B1

Hope this helps