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.
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.