Select the cell that you want to evaluate. ...
On the Formulas tab, in the Formula Auditing group, click Evaluate Formula.
Click Evaluate to examine the value of the underlined reference. ...
Continue until each part of the formula has been evaluated.
To see the evaluation again, click Restart.
