LOOKUP function reversed?

C

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
 
T

Teethless mama

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

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)
 
O

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top