Use look up table to return letter grade for grade sheet

[davidp]

Create a table anywhere in the spreadsheet. I have used K1:L100

In column K enter the numbers 1 to 100 (autofill does this easily)
In column L enter the appropriate grade for each row

Assuming item to be graded is in cell A1 the cell B1 formula
=VLOOKUP(A1,K1:L100,2) will give the grade

"steve harlan" <sha...@gmu.edu> wrote in message
news:b00f01c27a03$4b8ae6c0$2ae2...@phx.gbl...
> Hi,
>
> I'd like to use a lookup table to create an automatic
> routine to assign letter grades from a percent value:
>
> For example: 925 = A
>
> I have 200 students and I would like to do this for the
> entire column of grades using some sort of system such as
>
> 90-100 = A
> 80-89 = B
> 70-79 = C
> 60-69 = D
> < 60 = F
>
> I can get this to work for a single cell, but not for an
> entire column of data. Any suggestions would be very
> helpful.
>
> Thanks
>

[Aladin Akyurek]

Let B1 house the result of a student in A1.

In C1 enter & copy down:

=INDEX({"F";"D";"C";"B";"A"},MATCH(B1,{0;60;70;80;90}))

Is this not what you're looking for?

Aladin

[steve harlan]

[L. Howard Kittle]

Hi Steve,

Here is another way using VLOOKUP.

In A1:A5 enter 0, 60, 70, 80, 90.
In B1:b5 enter F, D, C, B, A.
In D1 enter =VLOOKUP(C1,A1:B5,2).
In C1 enter the test score and D1 returns the grade.

HTH
Regards,
Howard

"steve harlan" <sha...@gmu.edu> wrote in message
news:b00f01c27a03$4b8ae6c0$2ae2...@phx.gbl...

[Aladin Akyurek]

Let B1 house the result of a student in A1.

In C1 enter & copy down:

=INDEX({"F";"D";"C";"B";"A"},MATCH(B1,{0;60;70;80;90}))

Is this not what you're looking for?

Aladin

"steve harlan" <sha...@gmu.edu> wrote in message
news:b00f01c27a03$4b8ae6c0$2ae2...@phx.gbl...