• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 26. Using Formulas and Functions > Troubleshooting Formulas

Troubleshooting Formulas

The more complex the formula, the more likely you are to need time to get it working properly. Excel 2003 includes a variety of tools you can use to troubleshoot errors in formulas and in worksheets. 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:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint