Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"A+" convert to "4," "A-" to "3.7" etc...
I'm doing a GPA chart and want to have the letter grades entered in one cell
and have the corresponding number in the cell beside it... I'm not asking the right question so I'm not getting the right answer :-). Kevin |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"A+" convert to "4," "A-" to "3.7" etc...
Kevin
Look up "IF worksheet function" in help and it gives an example of exactly what you are looking for. ( in XL2K) Mike Rogers "Kevin Stone" wrote: I'm doing a GPA chart and want to have the letter grades entered in one cell and have the corresponding number in the cell beside it... I'm not asking the right question so I'm not getting the right answer :-). Kevin |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"A+" convert to "4," "A-" to "3.7" etc...
Hi Kevin,
Probably the simplest approach is to use VLOOKUP. Create a two column table with the letter grades in the first column and the numeric equivalents in the second: A+ 4.33 A 4.00 A- 3.67 and so on. Assume these are in the range A1:B15 and you want to enter a letter grade in cell D1, the formula in E1 would be =VLOOKUP(D1,$A$1:$B$15,2,False) This formula could be copied down column E as far as necessary. You can make it shorter by naming the cells A1:B15, G and removing FALSE. =VLOOKUP(D1,G,2) Cheers, Shane Devenshire "Kevin Stone" <Kevin wrote in message ... I'm doing a GPA chart and want to have the letter grades entered in one cell and have the corresponding number in the cell beside it... I'm not asking the right question so I'm not getting the right answer :-). Kevin |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"A+" convert to "4," "A-" to "3.7" etc...
Hi
Like this: =CHOOSE(MATCH(A1,{"A";"B";"C";"D";"E"},0),5,4,3,2, 1) (You can match up to 29 different values with this formula) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Kevin Stone" <Kevin wrote in message ... I'm doing a GPA chart and want to have the letter grades entered in one cell and have the corresponding number in the cell beside it... I'm not asking the right question so I'm not getting the right answer :-). Kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |