The time spent evaluating complicated nested formulas can be enormous. This new, excellent technique will save time.
From the Tools menu, select Formula Auditing, and then Evaluate Formula.
From the Formula Auditing toolbar, click Evaluate Formula.
The Evaluate Formula dialog box allows moving between the arguments in a formula and checking the calculation result step-by-step. Click Step In to move between arguments.
Screenshot // Stepping into a Formula