O'Reilly logo

Picture Yourself Learning Microsoft® Excel® 2010 by Laurie Ulrich Fuller, Deidre Hayes, Jeffery A. Riley

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

Understanding How Excel Handles Formula Errors

GRANTED, EXCEL CAN’T READ your mind. So it can’t know that you meant to subtract the July Expenses from July Revenues. Thus, it won’t bop you on the head when you accidentally subtract June’s Expenses from July Revenues instead. Still, there are some errors Excel knows are errors, such as dividing by zero. Excel helps you to identify most of these errors when they occur by displaying an error message such as #DIV/0 in the result cell of the formula containing the error. For other errors such as forgetting to type a closing parenthesis, Excel may flash a dialog box at you indicating the mistake (and offering you a chance right then to fix it), and not display an error message in the cell. All of ...

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