| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing an empty cell
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replacing certain characters in a cell | Excel Worksheet Functions | |||
| Replacing empty cells with '-' | Excel Worksheet Functions | |||
| Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| Replacing Contents of 1 Cell to Another. | Excel Discussion (Misc queries) | |||
Threaded Mode
