O'Reilly logo

Master VISUALLY® Excel® 2010 by Elaine Marmel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required