How to Correct a #DIV/0! Error in Excel 2010


The Excel application will display an error #DIV/0! When a particular number is either divided by zero or divided by a cell reference that contains no value.

The main reasons for this error to occur in an excel cell are: -

a) You might have entered a particular formula that performs an explicit division by the number zero. For example, 45/0.

b) You might have used a cell reference in a formula that contains a zero as a divisor. For example, if cell A1 contains ‘0’, then A2/A1 will result in an error.

c) You might have run a Macro that uses a formula or a function that returns #DIV/0! Error.

Consider the below example. The cell A1 contains ‘0’ and the cell A2 contains ‘1’.In this example the cells A3, A4 and A5 all return a #DIV/0! Error when the respective formulas displayed in the cells are used.

Figure 1

To correct the #DIV/0! Error, do the following

1) Ensure that, in a formula there is no divisor that has a zero value or a blank value

2) If a cell reference that you have used in the formula contains a blank value, try changing that cell reference to any other cell which does not contain a blank value or a zero value.

3) Enter the text #N/A in the cell that is referenced as a divisor in a formula. By typing #N/A, the result of the formula gets converted from #DIV/0! To #N/A, which indicates that, the divisor is not available.

Figure 2

4) You can use the IF formula to prevent the error #DIV/0! From occurring. For instance, in our example type the formula =IF(A1=0,0,A2/A1) instead of =A2/A1. By using the IF formula, the formula return a zero as the result.

Figure 3

so, this is how you can correct a #DIV?0! error in Excel 2010 Application


Read Other Applications