LOOKUP function reversed?

[Chris]

I have created a grading system using the LOOKUP function:

=LOOKUP(Y3,{0,64.5,66.5,69.5,72.5,76.5,79.5,82.5,86.5,89.5,92.5,96.5},{"F","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"})

How do I then convert the letter grades to GPA values?

For example A+ is worth 4.4 points, A is worth 4.0 points, A is worth 3.6
points, etc.

Thanks.

Chris

 

[Teethless mama]

Setup a lookup table and use either LOOKUP(), or VLOOKUP(). Your table must
in ascending order

 

[T. Valko]

Create a 2 column table with the letter grade in the left column and the
corresponding numeric value in the right column:

...........A..........B
1........A+......4.4
2........A........4.0
3........A-......3.6

X1 = some letter grade

=SUMIF(A1:A3,X1,B1:B3)

 

[OssieMac]

You could use exactly the same method but replace "A+" with 4.4, "A" with 4
etc.

Note if you want numeric values then replace both the double quotes and the
A+ as above. However, if you are happy with it returning numerics in text
format then just replace the "A+" with "4.4" (keeping the double quotes).

You might need format the column to one decimal place if you want it in
numeric format.