What formula are you using?

Regards,
Fred.

"LD" wrote in message
...
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.