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...