Converting letters to numbers

[Teacher]

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?

 

[David Biddulph]

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(B22))) entered as an array formula (Control Shift
Enter)

 

[Arvi Laanemets]

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)