How can I replace an empty cell with a zero value or get a formula to
recognise a blank cell as a zero value in a claculation? For example I have 6
marks for each of my students. I need to be able to sum their best 5 marks. I
can do this for those students who have completed all 6 tasks but for those
with marks missing the formula wont work. I am using office 2003.