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.
Search JabSto ::

Custom Search