assigning value to a column based on a table of values
Just use
=VLOOKUP(E1,B2:C9,2)
where E1 holds the score to be graded, B2:C9 holds the max and grade
columns.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Jacob" wrote in message
...
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
|