Microsoft Office Tutorials and References

In Depth Information

**Auditing Formulas**

Auditing Formulas

With Excel, you can create some fairly complex solutions. A cell can contain

a formula that uses values from multitudes of other cells and ranges. Working

through long, complex formulas to track down problems can be quite

tedious. The good news is that Excel has a way to help!

Formulas may contain precedents and may serve as dependents to other

formulas:

✓
Precedents
are cells or ranges that affect the active cell’s value.

✓
Dependents
are cells or ranges affected by the active cell.

It’s all relative! A cell often serves as both a precedent and a dependent.

Figure 4-13 shows a simple worksheet with some values and some

calculations. Cell B9 contains the formula =SUM(B3:B8). Cell F9 contains the

formula =SUM(F3:F8). Cell B18 contains the formula =B9-F9.

✓
Cells B3:B8 are precedents of B9, but at the same time cell B9 is

dependent on all the cells in B3:B8.

✓
Cells F3:F8 are precedents of F9, but at the same time cell F9 is

dependent on all the cells in F3:F8.

✓
Cells B9 and F9 are precedents of B18, but at the same time cell B18 is

dependent on cells B9 and F9.

Figure 4-13:

Understanding

precedents

and

dependents.