Excel Formula auditing tools
Select the cell that contains the formula, and on the Formulas tab, in the Formula Auditing group, click Evaluate Formula:
In the Evaluate Formula dialog box:
- Click the Evaluate button repeatedly to see the intermediate results as the formula is being calculated. The result of the evaluation is shown in italics.
- If the underlined part of the formula is a reference to another formula, click the Step In button to display the other formula in the Evaluation box.
- Click the Step Out button to go back to the previous cell and formula.
- Click the Restart button to see the evaluation again.
See also this tip in French: Évaluer la formule dans Excel.