Replace "#DIV/0!" with number "0" ?

[SteveMAC]

Is there a way to replace the error message "#DIV/0!" with
the number "0" so it will have a number value for use in a
second formula?

 

[Frank Kabel]

Hi
try a formula like the following:
=IF(A1=0,0,B1/A1)

 

[Chicago]

You can add an ISERROR on top of your existing formula.

=IF(ISERROR(your formula),0,(your formula))

 

[steveMAC]

That worked perfect, Thanks!!!

-----Original Message-----
You can add an ISERROR on top of your existing formula.

=IF(ISERROR(your formula),0,(your formula))

.

 

[JE McGimpsey]

Note that this will mask ALL errors (e.g., #VALUE!,#REF!,#NUM!,#N/A),
not just #DIV/0. Targeting specific errors usually results in a more
reliable model.

 

[Chicago]

True

-----Original Message-----
Note that this will mask ALL errors (e.g., #VALUE!,#REF!,#NUM!,#N/A),
not just #DIV/0. Targeting specific errors usually results in a more
reliable model.




.