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.
By Michael Price