How do I assign numerical values to a letter? Ex: A = 4, B=3, etc

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to do a spreadsheet function where I need to assign numerical
values to a letter. Like calculating your collge GPA. A = 4, B=3, C=2, D=1,
F=0. Can I do that?
 
For example, paste this to any cell except A1 and enter letter grades in A1:

=VLOOKUP(A1,
{"A+",4.5;"A",4;"B+",3.5;"B",3;"C+",2.5;"C",2;"C-",1.5;"D",1;"F",0}, 2, 0)

Regards,
Greg
 

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

Similar Threads

Scrabble Value calculation for Welsh words 0
averaging a column of letter grades into a numeric GPA 3
Returning 1 of 4 values if conditions are met 4
Convert GPA to Letter Grade 4
Vlookup and certain "bugs"? 4
LOOKUP function reversed? 3
HOW TO ASSIGN NUMERICAL VALUES TO LETTERS IN EXCEL 5
Converting a letter grade to a numerical value 3

Back
Top