Averaging Letters for Marksbook

Stolly24

New Member
Joined
Mar 6, 2019
Messages
1
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!
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,109,538
Messages
5,529,431
Members
409,876
Latest member
Akash Yadav
Top