View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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