Evaluating Formulas in Excel
Excel Video :Debugging a Formula By Using The Evaluate Formula Feature
Another way to evaluate formulas in Excel is the Evaluate Formula option that resides on the Formulas tab, in the Formula Auditing group.
As soon as you click this button, the Evaluate Formula dialog box will pop up, where you can inspect each part of your formula in the order the formula is calculated.
All you need to do is click the Evaluate button and examine the value of the underlined formula part.
The result of the most recent evaluation appears in italics.
Continue clicking the Evaluate button until each part of your formula has been tested.
To end the evaluation, click the Close button.
To start the formula evaluation from the beginning, click Restart.
If the underlined part of the formula is a reference to a cell containing another formula,
Click the Step In button to have that other formula displayed in the Evaluation box.
To get back to the previous formula, click Step Out.
Is the video helpful?
Drop your comment
Join our Advanced Excel Data Analytics Masterclass
Call us on 08062468296 or click www.leadleapconsult.com to register
Watch video Evaluating Formulas in Excel online without registration, duration hours minute second in high quality. This video was added by user Akerele Oluwasogo (Mr Excel) 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 72 once and liked it 4 people.