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



Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>