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

Chapter 5. Troubleshooting Formulas > Using the Formula Error Checker

Using the Formula Error Checker

If you use Microsoft Word, you're probably familiar with the wavy green lines that appear under words and phrases that the Grammar Checker has flagged as being incorrect. The Grammar Checker operates by using a set of rules that determine correct grammar and syntax. As you type, the Grammar Checker operates in the background and constantly monitors your writing. If something you write goes against one of the Grammar Checker's rules, the wavy line appears to let you know there's a problem.

Excel has a similar feature: the Formula Error Checker. It's similar to the Grammar Checker, in that it uses a set of rules to determine correctness, and it operates in the background to monitor your formulas. If it detects something amiss, it displays an error indicator—a green triangle—in the upper-left corner of the cell containing the formula, as shown in Figure 5.3.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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