Did you know you can use the Evaluate command in Excel to run a formula one step at a time to see how it operates?

To use this feature:

1) Select the cell with the formula you wish to investigate.

2) Select Formulas and click Evaluate Formula in the Formula Auditing group.

The formula displays with the first step underlined.

3) Press Evaluate repeatedly, to run the calculation forwards, a step at a time. The expressions in the formula are calculated, one by one in turn. You can view the intermediate values as they are displayed.

Find out more tips like this in Excel Functions & Formulas in easy steps.


192 pages
By Michael Price
ISBN: 97818404788815