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.
#DIV/0! Errors
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 ...
Get Master VISUALLY® Excel® 2010 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
