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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.