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)

  1. To evaluate a formula, ensure you have that cell selected; then click the Evaluate Formula command.article01_01-1
  2. A new window will pop-up, allowing you to walk through the formula.article01_02
  3. Each time you click the “Evaluate” button at the bottom of the dialog box, it evaluates the next step of the formula. article01_03
  4. Once the evaluation steps are complete, the “Evaluate” button will change to “Restart,” and the answer to the formula will appear. article01_04
Master Excel formulas in the Excel Functions and Formulas training.

For more ways to make Excel work for you, take a company group or online live training course from AdvantEdge Training & Consulting!