Formula request: converting letter grades to numbers so they can be averaged.

**Pyrrhonic** · 06-21-2007, 12:16 AM

Can anyone suggest a formula that would take letter grades (A, B, C, D, and E) and produce an average letter grade?

For example, a student gets a D on one assignment and a B on another. I want a formula that will produce "C".

Thanks!

**sweep** · 06-21-2007, 04:01 AM

Hi,

=CHAR(ROUND(AVERAGE(CODE(A1:E1)),0))

entered as an array formula will average the grades in cells A1 to E1.

To enter an array formula, use CTRL, SHIFT & ENTER - excel will display it as

{=CHAR(ROUND(AVERAGE(CODE(A1:E1)),0))}