Numerical grade to Alpha character

C

capecrusader

I am trying to make a spreadsheet to keep track of my grades. I am to the
point that I have a numerical grade, but I want to add another cell to keep
track of the letter grade. I want the alpha grade to update automaticly when
I update the numerical grade.
 
C

capecrusader0660

100-95 A
94-90 A-
89-87 B+
86-83 B
82-80 B-
79-77 C+
76-73 C
72-70 C-
69-67 D+
66-60 D
 
B

BenjieLop

<< 100-95 A
94-90 A-
89-87 B+
86-83 B
82-80 B-
79-77 C+
76-73 C
72-70 C-
69-67 D+
66-60 D
60 F >>
Click to expand...

First of all, the last line should read "<60" and not ">60." Here is
what you need to do.

In Cells A1 to A11, enter the following numbers,

0,60,67,70,73,77,80,83,87,90,95

and in Cells B1 to B11, enter the corresponding alpha grade

F,D,D+,C-,C,C+,B-,B,B+,A-,A


In Cell D1, enter this formula,

=IF(C1=\"\",\"\",VLOOKUP(C1,A1:B11,2))

where C1 is where you enter the numeric grade and Cell D1 will give you
the equivalent alpha grade.

Hope this is what you are looking for.

Regards.
 
D

Domenic

Let A1:B11 contain the following table...

0 F
60 D
67 D+
70 C-
73 C
77 C+
80 B-
83 B
87 B+
90 A-
95 A

Then, use the following formula...

=LOOKUP(C1,$A$1:$B$11)

....where C1 contains your numerical grade. Alternatively, you can
dispense with having a table and use the following formula instead...

=LOOKUP(C1,{0,60,67,70,73,77,80,83,87,90,95},{"F","D","D+","C-","C","C+",
"B-","B","B+","A-","A"})

Hope this helps!

capecrusader0660 said:
100-95 A
94-90 A-
89-87 B+
86-83 B
82-80 B-
79-77 C+
76-73 C
72-70 C-
69-67 D+
66-60 D
Click to expand...
 
Top