- Select a cell containing a complex formula you want to analyze
- Click "Formula" tab
- Find "Formula auditing" window
- Click "Evaluate formula" icon
- The "Evaluate formula dialog" opens
- Click "Evaluate" to calculate each nested formula one by one.
The current formula is underlined.