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


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

Hope this helps