software

How do I use Excel to average students grades given in letters?

Here are some ARRAY FORMULA* ideas....

*Note: For array formulas, hold down [Ctrl] and [Shift] when you press
[Enter], instead of just pressing [Enter].

For student grades (A,AB,B,....F) in B22

Example:
B2: A
C2: B
D2: A

E2:
=INDEX({quot;Aquot;,quot;ABquot;,quot;Bquot;,quot;BCquot;,quot;Cquot;,quot;CDquot;,quot;Dquot;,quot;Fquot;},ROUND( AVERAGE(LOOKUP(B22amp;quot;quot;,{quot;quot;,quot;Aquot;,quot;ABquot;,quot;Bquot;,quot;BCquot;,quot;Cquot;, quot;CDquot;,quot;Dquot;,quot;Fquot;},{FALSE,1,2,3,4,5,6,7,8})),0))
That formula returns: AB

Or
E2:
=AVERAGE(LOOKUP(B22amp;quot;quot;,{quot;quot;,quot;Aquot;,quot;ABquot;,quot;Bquot;,quot;BCquot;,quot;Cquot; ,quot;CDquot;,quot;Dquot;,quot;Fquot;},{FALSE,1,2,3,4,5,6,7,8}))
That formula returns 2.33

Something you can work with?
***********
Regards,
Ron

XL2002, WinXPquot;Mathsteachquot; wrote:

gt; How do I use Excel to average students grades given in letters?

Just for the heck of it........

Grades a A, B, C, D, F

Array entered: (doesn't account for empty cells or any other entries that
are not letter grades)

=CHAR(ROUND(AVERAGE(CODE(UPPER(A1:A5))),0) (ROUND( AVERAGE(CODE(UPPER(A1:A5))),0)=69))

Biff

quot;Mathsteachquot; gt; wrote in message
...
gt; How do I use Excel to average students grades given in letters?