Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I assign a number value to a letter grade in Excel?
This is very simple, but I can't find a variable assignment function. How
can I assign a number value to a letter grade presented in an Excel table? Thanks |
#2
|
|||
|
|||
You will probably have to set up a lookup table, and use the VLOOKUP function.
A 1 B 2 C 3 D 4 E 5 "BlackBond" wrote: This is very simple, but I can't find a variable assignment function. How can I assign a number value to a letter grade presented in an Excel table? Thanks |
#3
|
|||
|
|||
|
#4
|
|||
|
|||
Enter this formula in B1. You don't need a separate table, the table is in
the formula. =LOOKUP(A1,{0,50,65,70,85},{"F","D","C","B","A"}) Enter a number in A1 Or go with the VLOOKUP table as proposed by other responders. Gord Dibben Excel MVP On Tue, 5 Apr 2005 11:17:05 -0700, BlackBond wrote: This is very simple, but I can't find a variable assignment function. How can I assign a number value to a letter grade presented in an Excel table? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign a number to a name | Excel Worksheet Functions | |||
How do I get a letter in one cell ito equal a number in anotherl.. | Excel Discussion (Misc queries) | |||
assign number to sales invoice | Excel Worksheet Functions | |||
How can I assign a number to a string? | Excel Discussion (Misc queries) | |||
assign auto number and auto date | Excel Discussion (Misc queries) |