How do I assign numerical values to a letter? Ex: A = 4, B=3, etc
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? |
How do I assign numerical values to a letter? Ex: A = 4, B=3, etc
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 "Bob1023" wrote: 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? |
All times are GMT +1. The time now is 09:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com