Part II: Working with Formulas and Functions
FIGURE 19.1
Excel can check your formulas for potential errors.Using Formula Evaluator
Formula Evaluator lets you see the various parts of a nested formula evaluated in the
order in which the formula is calculated. To use Formula Evaluator, select the cell that
contains the formula and then choose Formulas ➪ Formula Auditing ➪ Evaluate Formula
to display the Evaluate Formula dialog box (see Figure 19.2).