In the Formulas tab, in the Formula Auditing group, there is a command that helps you evaluate the formulas you have written.
Example formula: =IF(A5>0,”True”,B5)
To evaluate a formula, ensure you have that cell selected; then click the Evaluate Formula command.
A new window will pop-up, allowing you to walk through the formula.
Each time you click the “Evaluate” button at the bottom of the dialog box, it evaluates the next step of the formula.
Once the evaluation steps are complete, the “Evaluate” button will change to “Restart,” and the answer to the formula will appear.
Master Excel formulas in the Excel Functions and Formulas training.
For more excel techniques see our Excel Training Class.