Best Microsoft Excel Bloggers

Thursday, October 1, 2009

Evaluate Formulas in Excel

Since we are talking about functions I thought I would mention the Evaluate Formula feature in Excel. You can see the different parts of a nested formula evaluated in the order the formula is calculated.

This is really useful for nested IF statements and other complex calculations

Select the cell you want to evaluate.
Only one cell can be evaluated at a time.
  • Click the Formula tab
  • Select Evaluate Formula to examine the value of the underlined reference. The result of the evaluation is shown in italics.
    If the underlined part of the formula is a reference to another formula, click Step In to display the other formula in the Evaluation box. Click Step Out to go back to the previous cell and formula.
    Continue until each part of the formula has been evaluated.
To see the evaluation again, click Restart.
To end the evaluation, click Close.

No comments:

Post a Comment

Ms. Excel- Resident Excel Geek