Microsoft Office Tutorials and References

In Depth Information

CHECK YOUR FORMULAS

for errors

When you create formulas, you can nest a formula

within another formula. Because there are so many

intermediate steps when you nest formulas,

determining the accuracy of your results may be

difficult. You can use the Evaluate Formula dialog box

to check the result of intermediate calculations to

determine if your result is correct.

When you open the Evaluate Formula dialog box, you

see your formula. The Evaluate Formula dialog box

steps you through the calculation one expression at

a time so you can see how Excel evaluates each

argument. Click the Evaluate button to begin the

process. Excel underlines individual expressions. You

can click the Evaluate button again to see the results

of an expression. The results of expressions appear

in italics.

If you base the reference on another formula, you

can click the Step In button to display the formula.

Click the Step Out button to return to the reference.

After you step through the entire formula, Excel

displays the result and a Restart button. Click the

Restart button to evaluate your expression again.

2

1

Click in the cell that contains the

formula you want to check.

3

2

Click the Formulas tab.

3

Click Evaluate Formulas in the

Formula Auditing group.

1

l
The Evaluate Formula dialog box

appears.

4
Click Evaluate.

l
Excel begins evaluating the

formula.

4

54