Get rid of DIV/0 error message

[Jeff]

Is there a command to return a value of 0 instead of DIV/0 error message?

Thanks!!

 

[Pete_UK]

Something like this:

=IF(B1=0,0,A1/B1)

or more generally:

=IF(ISERROR(your_formula),0,your_formula)

though this would mask all errors.

Hope this helps.

Pete

 

[Michael]

=IF(Iserror(YourCellreference),0,(YourCellreference))

 

[Jeff]

Thank you!
--
Jeff

Something like this:

=IF(B1=0,0,A1/B1)

or more generally:

=IF(ISERROR(your_formula),0,your_formula)

though this would mask all errors.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome.

Pete