i-nth logo
Two quick ways to troubleshoot broken Excel formulas
8 May 2017

Excel has built-in tools that are very useful for troubleshooting formulas, even if the formulas are complex:

  • Trace Precedents.
  • Evaluate Formula.

The Evaluate Formula window and the tracer arrows are great tools that can be used to help you find the reason for an error.

Full article: Two quick ways to troubleshoot broken Excel formulas