Chapter 15. Working with Logical and Error Trapping Formulas
Understanding Error Values
When Excel cannot properly calculate a formula you enter, it returns one of seven possible errors. Tracking down these errors and correcting them can be tricky unless you understand what causes an error to appear.
The #DIV/0! error appears in your worksheet when you attempt to divide a value by zero. Dividing by zero is not a valid mathematical operation. Excel also returns this error if you attempt to divide by a blank cell because Excel treats a blank cell as if it contains the value zero. As a result, you commonly see this error when you set up a formula for data that you have not yet entered. In the figure, the worksheet cell displays the #DIV/0 ...