software

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?

minmaxgrade
023
255
566
677
788
8119
111810
182311

Jacob

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)

quot;Jacobquot; gt; wrote in message
...
gt; I am correcting an exam and I have automatically generated the score of
the
gt; students. These I have in columns. Further I have a translation code that
gt; showes how a score relates to a grade. this is shown below. Here the
interval
gt; from min to max is the score that produce the grade. For example if the
score
gt; is between 2 and 5 the grade is 5.
gt;
gt; How do I make the translation from score to grade automatically?
gt;
gt; min max grade
gt; 0 2 3
gt; 2 5 5
gt; 5 6 6
gt; 6 7 7
gt; 7 8 8
gt; 8 11 9
gt; 11 18 10
gt; 18 23 11
gt;
gt; Jacob
Your max values are the same as the min values for the next grade. If
someone has a score of 2 or 5, which grade would be awarded? Assuming
that it would be the higher grade, the following should do what you
want:

=VLOOKUP(A1,$H$2:$J$9,3,TRUE)

where I have assumed your table (with headings) occupies cells H1 to
J9, and that the raw score is in A1. You can enter the formula, say, in
B1 and copy down.

Hope this helps.

PeteThanks to you both

quot;Jacobquot; skrev:

gt; I am correcting an exam and I have automatically generated the score of the
gt; students. These I have in columns. Further I have a translation code that
gt; showes how a score relates to a grade. this is shown below. Here the interval
gt; from min to max is the score that produce the grade. For example if the score
gt; is between 2 and 5 the grade is 5.
gt;
gt; How do I make the translation from score to grade automatically?
gt;
gt; minmaxgrade
gt; 023
gt; 255
gt; 566
gt; 677
gt; 788
gt; 8119
gt; 111810
gt; 182311
gt;
gt; Jacob