Forum Discussion
Formula to average Letter grades
Hi All, I am not an expert in excel but I a, trying work out how I can calculate an average of grades. There are 7 questions each scored with a grade and then I need to average the scores. I add...
It is helpful to know the operating system and Excel version, as different approaches may be required depending on the version and OS.
Formula for Excel 2019 and Excel for Office 365:
=SWITCH(MID(A2,1,1),"A",4,"B",3,"C",2,"D",1,"F",0)
NOTE: This formula will not work in older versions of Excel because it uses the new SWITCH function.
How to Convert a Letter Grade to GPA points in newer versions of Excel
https://www.techonthenet.com/excel/formulas/convert_letter_grade_to_gpa.php
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.