Page 375 - Excel 2013 All-in-One For Dummies

Selecting the Trace Error option is a lot like using both the Trace Precedents and the Trace Dependents command button options, except that the Trace Error option works only when the active cell contains some sort of error value returned by either a bogus formula or a reference to a bogus formula. In tracking down the actual cause of the error value in the active cell (remember that these error values spread to all direct and indirect dependents of a formula), Excel draws blue tracer arrows from the precedents for the original bogus formula and then draws red tracer arrows to all the dependents that contain error values as a result.
Figure 2-9 shows the sample worksheet after I made some damaging changes that left three cells — C12, E12, and E13 — with #DIV/0! errors (meaning that somewhere, somehow, I ended up creating a formula that is trying to divide by zero, which is a real no-no in the wonderful world of math). To find the origin of these error values and identify its cause, I clicked the Trace Error option on the Error Checking command button’s drop-down menu while cell E12 was the active cell to engage the use of Excel’s faithful old Trace Error feature.
Formula Auditing 357
Figure 2-9:
Using the Trace Error option to show the precedents and dependents of the formula.
Book III Chapter 2
Logical Functions and Error Trapping