How to show zero for #DIV/0!
 

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

Thanks,
Brett

How to show zero for #DIV/0!
 

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

"Brett Romero" wrote in message
...
Is there a way to replace #DIV/0! with a zero?

Thanks,
Brett

How to show zero for #DIV/0!
 

=if(a2=0,0,a1/a2)

Maybe???



Brett Romero wrote:

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

Thanks,
Brett

--

Dave Peterson

How to show zero for #DIV/0!
 

=IF(ISERR(YourFormula),0,YourFormula)


Vaya con Dios,
Chuck, CABGx3



"Brett Romero" wrote in message
...
Is there a way to replace #DIV/0! with a zero?

Thanks,
Brett