Hello,
What formula should I use to calculate students' average course marks when some of the cells include students' authorised absences (A)? Also, when there are 3 or more absences the formula should display 'Too many absences' instead of calculating an average mark.
Thanks
Solved by C. Y. in 12 mins