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!
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!
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))}
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
With A-E in A1:A5, put this in B1 and drag down
=CODE(A1) then in C1 put this
=CHAR(AVERAGE(B1:B5))
oldchippy
-------------
![]()
![]()
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks