LOOKUP function reversed?
 

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,8 6.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

LOOKUP function reversed?
 

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



"Chris" wrote:

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,8 6.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

LOOKUP function reversed?
 

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)


--
Biff
Microsoft Excel MVP


"Chris" wrote in message
...
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,8 6.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

LOOKUP function reversed?
 

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.

--
Regards,

OssieMac


"Teethless mama" wrote:

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



"Chris" wrote:

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,8 6.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