Troubleshooting Formulas
The more complex the formula, the more likely you are to need time to get it working properly. Excel 2002 includes a variety of tools you can use to troubleshoot errors in formulas and in worksheets. Excel 2002 adds several new error-checking tools that can make your worksheets more accurate. This section discusses the most useful options.
How Formula AutoCorrect Works
Under most circumstances, Excel won't let you enter a formula using incorrect syntax. If you make one of many common mistakes in formula syntax or punctuation, Excel offers to correct the mistake for you, and generally the correction is appropriate. This feature, called Formula AutoCorrect, can detect and repair any of the following errors:
Unmatched parentheses, ...
Get Special Edition Using Microsoft® Office XP 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.