#DIV/O!
Maybe something like this...
If you have something like this: =A1/B1, and B1 is an empty cell then try it
like this:
=IF(B1="",0,A1/B1)
--
Biff
Microsoft Excel MVP
"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
|