Excel: Evaluating Formulas

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.
article01_01-3

 
A new window will pop-up, allowing you to walk through the formula.
article01_02-1

 
Each time you click the “Evaluate” button at the bottom of the dialog box, it evaluates the next step of the formula.
article01_03-1

 
Once the evaluation steps are complete, the “Evaluate” button will change to “Restart,” and the answer to the formula will appear.
article01_04-1

 
For more office techniques see our MS Office Tips.