|  

» Stepping into a Formula

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.
OR
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
Stepping into a FormulaStepping into a Formula


Rate This Tip
12 34 5
Rating: 2.53     Views: 26252
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments