Microsoft Office Tutorials and References
In Depth Information
CHECK YOUR FORMULAS
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
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.
Click in the cell that contains the
formula you want to check.
Click the Formulas tab.
Click Evaluate Formulas in the
Formula Auditing group.
l The Evaluate Formula dialog box
4 Click Evaluate.
l Excel begins evaluating the