Using Excel's Formula Evaluator
Select the cell that contains the formula, and on the Formulas tab, in the Formula Auditing group, click Evaluate Formula:
The Evaluate Formula dialog box was appeared.
Click the Evaluate button repeatedly to see the intermediate results as the formula is being calculated.
Permission is granted for article quotations from OfficeToolTips, provided the direct link to the source articlehttp://www.officetooltips.com/excel 2016/tips/using excel s formula evaluator.html