O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

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

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

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