You should only be getting the divide/overflow when you divide by zero. If
the actual answer is zero, it should put a "0" in the cell. Did I
misunderstand the question?
--
gevans


"Daniell" wrote:

What I am working with is a simple divide statment using two worksheets.

=('Product'!P20/'Product'!P21)

If the answer comes out to zero I get the #DIV/0!, is there a solution to
just putting a zero in that cell?

Thanks in advance.