Part IV: Using Advanced Excel Features
666
FIGURE 32.10Excel can check your formulas for potential errors.
FIGURE 32.11After you click an error, Smart Tag gives you a list of options.
In many cases, you will choose to ignore an error by selecting the Ignore Error option. Selecting
this option eliminates the cell from subsequent error checks. However, all previously ignored
errors can be reset so that they appear again. (Use the Reset Ignored Errors button in the Formulas
tab of the Excel Options dialog box.)