Hi
You need to wrap your division with an IF() so it will evalluate the result
before it puts anything in the cell. Try something like:
=IF(A20,A3/A2,0)

--
Andy.


"Helpwanted" wrote in message
...
I have a function that divides two numbers, sometimes those numbers are 0
so
the result is # DIV/0!. My second function is based on the result of the
first function. Since there isnt always data available for the first
function
I get the # DIV/0! error and my final calculation wont calculate. I need
the
final calculation to disregard any 0 cells or # DIV/0! errors and still
calculate the data that is available.