Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting letters to numbers
I am a teacher looking for an easy way to convert letters to numbers. My
students get their grades A - F. To calculate their average grade, I need to convert the letters to numbers, calculate the average and then back to letters. Typically the list would look something like this: Subject 1 Subject 2 Subject 3 Average John B C A Mary A B C Ed A A E Any takers? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting letters to numbers
"Teacher" wrote in message
... I am a teacher looking for an easy way to convert letters to numbers. My students get their grades A - F. To calculate their average grade, I need to convert the letters to numbers, calculate the average and then back to letters. Typically the list would look something like this: Subject 1 Subject 2 Subject 3 Average John B C A Mary A B C Ed A A E Any takers? Try =CHAR(AVERAGE(CODE(B2:D2))) entered as an array formula (Control Shift Enter) -- David Biddulph |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting letters to numbers
Hi
=MATCH(Grade,{"A";"B";"C";"D";"E";"F"},0) , or =MATCH(Grade,{"F";"E";"D";"C";"B";"A"},0) , depending on order you want the numbers to be. The 1st formula returns numbers 1 through 6 for grades A through F, the second one returns numbers 6 through 1 for grades A through F. Replace Grade with a passing reference with grade to convert. Another possibility: =CODE(Grade)-64 , or =-(CODE(Grade)-71) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Teacher" wrote in message ... I am a teacher looking for an easy way to convert letters to numbers. My students get their grades A - F. To calculate their average grade, I need to convert the letters to numbers, calculate the average and then back to letters. Typically the list would look something like this: Subject 1 Subject 2 Subject 3 Average John B C A Mary A B C Ed A A E Any takers? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
csv converting numbers to scientific format | Excel Discussion (Misc queries) | |||
How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
Converting Numbers | Excel Discussion (Misc queries) | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
roundoff when converting text to numbers | Excel Worksheet Functions |