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
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.