Averaging Letters for Marksbook

[Stolly24]

Hi there,
I realise it has been asked before but I could not wrap my head around how to average out letters for a marks book. My spreadsheet is for athletics and each grade cell is reliant on an IF function eg. =IF(C2<15,"A",IF(C2<17,"B",IF(C2<21,"C",IF(C2>21,"D")))). I am hoping that I can average out the students grades at the end to give me a final grade for the unit

Thanks!

 

[footoo]

What about a score of 21 ?
Presumably your formula should be : =IF(C2<15,"A",IF(C2<17,"B",IF(C2<21,"C",IF(C2>=21,"D"))))

To get average letter grade of cells C2:C10 (taken from here : https://www.mrexcel.com/forum/excel-questions/964040-average-letter-gradings.html) :

=CHAR(ROUND(AVERAGE(0+CODE(D3:D10)),0))

Enter with Ctrl+Shift+Enter