Home » Remove the #DIV/0! Error in Excel

Remove the #DIV/0! Error in Excel

Remove the #DIV/0! Error in Excel

The #DIV/0! error occurs when you divide something by zero or by a cell that is empty.  The most likely occurrence is where you have set up formulas in a worksheet but have not yet entered values in the cells the formula references.

In the example below % dropped is calculated by dividing dropped calls by no of calls. The third and fourth rows return the #DIV/0! error as Bill and Brenda’s call data has not yet been entered.  The error makes your worksheet look wrong whereas in fact it is just waiting for data.

DIV#0 error

You can get around this issue with the IFERROR function (2007 and onwards) IF or a combination of IF and ISERROR.

IFERROR

IFERROR is the simplest solution. For example if your formula was =A1/A2 you would enter =IFERROR(A1/A2,“”) to return a blank or =IFERROR(A1/A2,0) to return a zero in place of the error.

If you prefer, use an IF statement such as =IF(A2=0,0,A1/A2).  This will return a zero if A2 contains a zero or is empty.

ISERROR

Another way of suppressing the #DIV/0! error is to use the ISERROR function. The ISERROR returns TRUE where there is an error and FALSE where there isn’t. You would enter =IF(ISERROR(A1/B1),0,A1/B1) to return a zero instead of an error.

 

Leave a Reply