View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jacob
 
Posts: n/a
Default assigning value to a column based on a table of values

Thanks to you both

"Jacob" skrev:

I am correcting an exam and I have automatically generated the score of the
students. These I have in columns. Further I have a translation code that
showes how a score relates to a grade. this is shown below. Here the interval
from min to max is the score that produce the grade. For example if the score
is between 2 and 5 the grade is 5.

How do I make the translation from score to grade automatically?

min max grade
0 2 3
2 5 5
5 6 6
6 7 7
7 8 8
8 11 9
11 18 10
18 23 11

Jacob