MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.