This is a discussion on How to Correct a #DIV/0! Error in Excel 2010 within the Applications forums, part of the Tutorials category; How to Correct a #DIV/0! Error in Excel 2010 The Excel application will display an error #DIV/0! When a particular ...
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
Bookmarks