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
