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
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
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.
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
Identifying Formula Precedents
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
1. Click the cell whose dependents you want to
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.