Get rid of DIV/0 error message
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
On Dec 11, 4:38*pm, Jeff wrote:
Is there a command to return a value of 0 instead of DIV/0 error message?
Thanks!!
--
Jeff
|