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

Chapter 5. Troubleshooting Formulas > Choosing an Error Action

Choosing an Error Action

When you select the cell, Excel displays a Smart Tag beside it. If you hover your mouse pointer over the icon, a pop-up message describes the error, as shown in Figure 5.4. The Smart Tag doubles as a drop-down list with the following actions:

  • Help on this Error— Choose this option to get information on the error via the Excel Help system.

  • Show Calculation Steps— Choose this option to run the Evaluate Formula feature. See “Evaluating Formulas,” later in this chapter.

  • Ignore Error— Choose this option to leave the formula as is.

  • Edit in Formula Bar— Choose this option to display the formula in Edit mode in the formula bar. This enables you to fix the problem by editing the formula.

  • Error-Checking Options— Choose this option to display the Error Checking tab of the Options dialog box (discussed next).

  • Show Formula Auditing Toolbar— Choose this option to display the Formula Auditing toolbar. See “Auditing a Worksheet,” later in this chapter.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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