Evaluating Formulas in Excel

Evaluating Formulas in Excel
If you build formulas with the help of the Function Library, a dialog box pops up, and helps you fill in the different areas with the correct information, then evaluates your formula as you move through the setup process.
If you like to write your formulas without that help of the Function Library, then what can you do to audit your formulas? Luckily, there is an “Evaluate Formula” command to help with that. This is especially helpful if you are tweaking an Excel workbook that is being used regularly, and you want to make sure it is giving you the correct results.
Use the steps below to learn how to use this helpful tool:

  1. In the Formulas tab, within the Formula Auditing group, there is a command that helps you evaluate formulas you have written.
  2. Example formula: =IF(A5>0,”True”,B5)
  3. To evaluate a formula, ensure you have that cell selected, then click the Evaluate Formula command. Evaluate Formulas in Excel - Evaluate Command
  4. A new window will pop-up and allow you to walk through the formula Evaluating Formulas in Excel - Pop up window
  5. Each time you click the “Evaluate” button at the bottom of the dialog box, the wizard evaluates the next step of the formula.Evaluating Formulas in Exceln- Next formula
  6. Once the evaluation steps are complete, the “Evaluate” button will change to “Restart” and the answer to the formula will appear.Evaluating Formulas in Excel - Restart

Functions and formulas are an important and powerful part of Excel that help you work more efficiently by automating your workload.

Start exploring what Excel can do for you, with a company group or online live training course from AdvantEdge Training & Consulting!