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

Ribbon to display both the direct and indirect dependents and then clicked it a third time to display the dependents on another worksheet.
Figure 2-7:
Clicking
the Trace Dependents command button shows
all the dependents of the formula in cell B9.
Formula Auditing 353
As this figure shows, Excel first draws tracer arrows from cell B9 to cells C12 and C13, indicating that C12 and C13 are the direct dependents of cell B9. Then, it draws tracer arrows from cells C12 and C13 to E12 and E13, respec- tively, the direct dependents of C12 and C13 and the indirect dependents
of B9. Finally, it draws a tracer arrow from cell E12 to another sheet in the workbook (indicated by the dotted tracer arrow pointing to the worksheet icon).
Error checking
Whenever a formula yields an error value other than #N/A (refer to Table 2-1 for a list of all the error values) in a cell, Excel displays a tiny error indicator (in the form of the triangle) in the upper-left corner of the cell, and an alert options button appears to the left of that cell when you make it active. If you position the mouse or Touch pointer on that options button, a drop-down button appears to its right that you can click to display a drop-down menu, and a ScreenTip appears below describing the nature of the error value.
Book III Chapter 2
Logical Functions and Error Trapping