Forum Discussion

Pinkelephants2020's avatar
Pinkelephants2020
Copper Contributor
Oct 22, 2020

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...
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Oct 22, 2020
for Excel 2016 formula =CHAR(CEILING(SUMPRODUCT(--(CODE(UPPER(B2:H2))))/COUNTA(B2:H2);1))
devyadav2008's avatar
devyadav2008
Brass Contributor
Dec 03, 2020
Auto correction option path is

go to file-option-proofing-Auto Correct Option

Resources