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
Смотрите видео Evaluating Formulas in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Akerele Oluwasogo (Mr Excel) 01 Январь 1970, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 72 раз и оно понравилось 4 людям.