5. Troubleshooting Formulas
IN THIS CHAPTER
Understanding Excel’s Error Values
Using the Formula Error Checker
Despite your best efforts, the odd error might appear in your formulas from time to time. These errors can be mathematical (for example, dividing by zero), or Excel might simply be incapable of interpreting the formula. In the latter case, problems can be caught while you’re entering the formula. For example, if you try to enter a formula that has unbalanced parentheses, Excel won’t accept the entry; it displays an error message instead. Other errors are more insidious. For example, your formula might appear to be working—that is, it returns a value—but the result is incorrect ...
Get Formulas and Functions with Microsoft® Excel 2003 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.
