Why cell contains error value?

If you have a formula, which produces error value, Dependency Auditor quickly finds source of this error.
Trace Error command analyzes all precedents of the formula, and show only that one's which has errors. Also, it filters all errors and show only beginning of the error chain, so you will see only sources of error, not a long chain with errors.