software

Is there a way to replace #DIV/0! with a zero?

Thanks,
Brett
A lttle additional information, the cell that produces division by zero
should actually be blank because it didn't apply during this particular
scenario. So I guess there needs to be a check to make sure the cell isn't
blank.

Brett

quot;Brett Romeroquot; gt; wrote in message
...
gt; Is there a way to replace #DIV/0! with a zero?
gt;
gt; Thanks,
gt; Brett
gt;
=if(a2=0,0,a1/a2)

Maybe???
Brett Romero wrote:
gt;
gt; Is there a way to replace #DIV/0! with a zero?
gt;
gt; Thanks,
gt; Brett

--

Dave Peterson

=IF(ISERR(YourFormula),0,YourFormula)Vaya con Dios,
Chuck, CABGx3
quot;Brett Romeroquot; gt; wrote in message
...
gt; Is there a way to replace #DIV/0! with a zero?
gt;
gt; Thanks,
gt; Brett
gt;
gt;