Instructions:

  1. Select a cell containing a complex formula you want to analyze
  2. Click "Formula" tab
  3. Find "Formula auditing" window
  4. Click "Evaluate formula" icon
  5. The "Evaluate formula dialog" opens

  6. Click "Evaluate" to calculate each nested formula one by one.
    The current formula is underlined.