Converting letters to numbers "Teacher" <Supporter4ever[ at ]hotmail.com> 08.06.2006 10:14:20 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?

Re: Converting letters to numbers "Ardus Petus" <ardus.petus[ at ]laposte.net> 08.06.2006 12:03:39 Try: =CHAR(ROUND(SUM(CODE(B2:D2))/COUNTA(B2:D2),0)) HTH -- AP "Teacher" <Supporter4ever[ at ]hotmail.com> a écrit dans le message de news: e68t4c$12f$1[ at ]bat-news01.banetele.basefarm.net... [Quoted Text] >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? >

Re: Converting letters to numbers "Ardus Petus" <ardus.petus[ at ]laposte.net> 08.06.2006 12:06:39 Better: =CHAR(ROUND(AVERAGE(CODE(B2:D2)),0)) This (as the previous one) is an array formula, to be validated with Ctrl+Shift+Enter (not just Enter) HTH -- AP "Teacher" <Supporter4ever[ at ]hotmail.com> a écrit dans le message de news: e68t4c$12f$1[ at ]bat-news01.banetele.basefarm.net... [Quoted Text] >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? >

RE: Converting letters to numbers TomB. 21.06.2006 15:32:00 I was reading your request for an Excel formula that will calculate your students AVERAGE grades….the answer you received from Ardus Petus will work IF your students take three subjects or less. If you go to four or more, there is a possibility of getting a wrong average…for instance, here are John's and Mary's grades…evidenced by grades alone, they are identical. Change those grades to possible numeric values and the Average changes! While Mary benefits from the use of Average Grades, John is cheated of his higher marks…politically correct, but at John's expense. ( A: 90+ B: 80-89 C: 70-79 D: 60-69 F: <60 ) Sub 1 Sub 2 Sub 3 Sub 4 Average John A A A B A Mary A A A B A ------------- ------------- ------------- ------------- ------------- -------------- John 95 100 97 89 95 Mary 92 92 90 83 89 If this isn't an issue, no sweat….however, if you want to extend your capabilities beyond three subject, you need to create a formula that will convert the numeric grades into letter grades. Here is an example: =IF(C6>89,"A",IF(C6>79,"B",IF(C6>69,"C",IF(C6>59,"D","F")))) Hope this is a help, TomB. "Teacher" wrote: [Quoted Text] > 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? > > >