Is there a way to format cell not to display #DIV/0!
Posted by Julie Jevremov on October 05, 2001 1:20 PM
Does anyone know of a way to make the result of dividing a number by zero something other than #DIV/0!
I love the formatting feature that replaces zero's with "-" and was wondering if there was a similar format for #DIV/0!
Posted by IML on October 05, 2001 1:28 PM
One way may be to check if your denominater is zero before caluclating.
If your formula is =a1/b1, you can check B1 with
=IF(B1,A1/B1,0)
This will get a zero instead of the error.
