Question

if grades were

B
C
C
B
C
C
A

how would you compute the letter grades with an excel function to automatically formulate numerical grades from letter grades?

Answer 1

Let’s say that these letter grades are entered in the cell A1 to A7. Basically they are in column A.

Now, if we want to provide them a score. For example, we could assign 80 to A, 70 to B, and 60 to C, then we need to create a data table where we can keep this relations.

Let’s say the table is from A12 to B14.

Now, let’s try to use the data from the table A12:B14 to fill the corresponding values in column B then we need to enter the formulas as

=LOOKUP(A1,$A$12:$B$14)

Then copy the value and paste it on all cells in the column B.

It will look like the picture below

fix LOOKUP(A3,$A$12:$B$14) IT B3 A B C D E F G Н J K L 1 В 70 2 C 60 3 C 60 4 В 70 5 C 60 6 C 60 7 A 80 8 10 11 12 A 80 13 В 70 14 C 60 15 16 17 Sheet19 Sheet15 Sheet11 Sheet12 Sheet13 Sheet14 Sheet16 Sheet17 Sheet18 160% READY LL 은"

The formulas used is shown below

LOOKUP(A3,$A$12:$B$14) ВЗ A В C D E F =LOOKUP(A1,$A$12:$B$14) |=LOOKUP(A2,$A$12:$B$14) |=LOOKUP(A3,$A$12:$B$14) LOOKUP(A4,$A$12:$B$14) =LOOKUP(A5,$A$12:$B$14) =LOOKUP(A6,$A$12:$B$14) =LOOKUP(A7,$A$12:$B$14) 1 В 2 C 3 C 4 В 5 C 6 C 7 A 8 9 10 11 12 A 80 13 В 70 14 C 60 15 16 17 Ф) Sheet11 Sheet12 Sheet13 Sheet14 Sheet15 Sheet16 Sheet17 Sheet18 Sheet19 160% READY 3