Microsoft Office Tutorials and References

In Depth Information

**Checking for Errors Automatically One at a Time**

5.
Continue to click the Evaluate button until

each step of the formula is solved.

You can trace a cell’s precedents as well. A

precedent
is a cell referred to by the formula in

the current cell. For example, if you traced the

precedents of cell G10, Excel would point to

cells B2 and G9, because they are referenced in

its formula.

6.
After evaluating the formula, click Restart

(see Figure 4-9) to evaluate it again from the

beginning, or click Close to close the Evaluate

Formula window.

Dependents/Precedents

in Other Worksheets

Dependents and precedents may not be

cells in the current worksheet; they may be

located in another worksheet or workbook.

In any case, Excel can help you to identify

the cells that relate to the current cell.

Figure 4-9

Continue to evaluate the formula until

you reach the final result.

Follow these steps to trace a cell’s dependents

(cells whose value depend on the value of the

current cell):

Identifying Formula Precedents

and Dependents

The value of a cell rarely depends on just what is

entered into it. Often, a cell contains a formula,

and its value depends on the values of the cells

referenced in that formula. In addition, the cell

and its result might be referenced in yet another

cell.

1.
Click the cell whose dependents you want to

trace.

2.
Click the Trace Dependents button on the

Formulas tab. Blue arrow(s) point from

the selected cell to cells that depend on the

current cell’s value, as shown in Figure 4-10.

3.
To trace dependency further, click the Trace

Dependents button again. Arrows point from

the dependent cells identified in Step 2, to

any cell(s) that depend on their value.

If you want to see how the value of one cell

might affect others, you can trace its dependents

using the Trace Dependents button. A
dependent

is a cell whose value depends on the value in

another cell. For example, suppose cell G10

contains the formula B2/G9. If you traced the

dependents of cell B2, Excel would point to cell

G10 with a blue arrow, because the value in G10

depends on the value in cell B2.

4.
Repeat Step 3 to trace dependents back as far

as you want to go. When there are no more

dependents, Excel beeps to tell you so.