Q: Excel function

[JIM.H.]

Hello,

Grade Letter
100-96 A
95-90 A-
89-87 B+
86-82 B
81-80 B-
79-77 C+
76-72 C
71-70 C-
69-67 D+
66-62 D
61-60 D-
59 or < F

A column keeps Grade, wow can I get Excel figure out Letter in B column?
Thanks,
Jim.

 

[Don Guillett]

Have a look in HELP index for VLOOKUP

 

[B. R.Ramachandran]

Let's imagine that the number grades are in column A and you want the letter
grades to go to column B, and all data start from Row 2. Make your grading
scale in two empty columns (e.g., C and D), IN ASCENDING ORDER, as follows:
C D
Grade (cutoff) Letter
0 F
60 D-
62 D
67 D+
70 C-
72 C
77 C+
80 B-
82 B
87 B+
90 A-
96 A

In B2, enter the formula, =VLOOKUP(A2,$C$2:$D$13,2,-1), and fill-in the
formula down to the last row.
Note: Make sure that the grades in Col A are rounded off to whole numbers,
to avoid a scenario such as 95.9999 translating into A- (instead of A)!

Regards.
B.R.Ramachandran