#DIV/0! Is there a way to show 0 or 0%

[MickJJ]

I have formulaes that sometime return #DIV/0! Is there a way that I can
return a value 0 or 0% instead of the error?

 

[mzehr]

Hi Mick,
Try
=IF(ISERROR(+A1/A2),0,+A1/A2)

 

[Frank Kabel]

Hi
try something like
=IF(N(A1)=0,0,B1/A1)

 

[Myrna Larson]

There's no need for the plus signs in your formula:

=IF(ISERROR(A1/A2),0,A1/A2)

will work just fine.