Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to equate Text Drop Down selections to numerical values | Excel Discussion (Misc queries) | |||
text has numerical values | Excel Worksheet Functions | |||
Assign numerical values to text codes | Excel Worksheet Functions | |||
How can I assign a number value to a letter grade in Excel? | Excel Worksheet Functions | |||
Assign values to names in a drop-down list? | Excel Discussion (Misc queries) |