=IF(A2=0,0,A1/A2)
or in Excel 2007
=IFERROR(A1/A2,0)
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"painter50" wrote in message
...
I get this #DIV/O! when I divide two cell that both total 0.
These cell will not always be used in the spreadsheet. Is there any way
to
show the total of these cell to be 0 when not used?
--
Joe