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
|