Excel Formula Evaluator
Select the cell that contains the formula, and on the Formulas tab, in the Formula Auditing group, click Evaluate Formula:
The Evaluate Formula dialog box was appeared.
Click the Evaluate button repeatedly to see the intermediate results as the formula is being calculated.
See also this tip in French: Évaluer la formule dans Excel.