You could speed up the process of overall assignment score by actually using the average function and also use the colour scale in the conditional format section to achieve the same results, the benefit of using AVERAGE over the sum/4 is it doesn't matter how many assignments there are and the actual formula is faster. I hope this helps.
You could speed up the process of overall assignment score by actually using the average function and also use the colour scale in the conditional format section to achieve the same results, the benefit of using AVERAGE over the sum/4 is it doesn't matter how many assignments there are and the actual formula is faster. I hope this helps.
Great idea! Thank you for that!
what if it is in decimal. like 1.5, 2.5 and so on?