Hi,

Let's say I have a number in my cell, for this example the number is 47. And with that number I want to give it a grade score of a 15. How would I do that? Like if a certain range is from 0-10 the result will be 5. If the result is 30-35 the result is 11 etc.

ex:

Column A . Column B
47 15
32 11
10 5
50 20