If you cannot immediately see the source of an error in a nested formula, this tool will walk you through the intermediary calculations.
A)Evaluate Formula
B)Trace Dependents
C)Trace Precedents
D)IFERROR

Question

Quizplus · Accepted Answer

The Evaluate Formula tool shows every calculation step in a formula, making it easier to identify where the error occurred within a nested formula. Trace Dependents and Precedents show the relationships between cells and may not necessarily help identify errors within a formula. IFERROR is helpful for handling errors but does not walk through intermediary calculations.

If You Cannot Immediately See the Source of an Error