Microsoft Office Tutorials and References
In Depth Information
Troubleshooting Errors
Chapter 9
Working with Formulas and Functions
Formula Omits Adjacent Cells: This error
means a formula refers to a group of cells
that have numbers adjacent to it. Study the
formula to make sure you didn’t forget to
include additional cell references in the
display tracer arrows, which are arrows that show
the relationship between the active cell and its
related cells. It traces dependents , which are other
cells that are affected by the current cell, and
precedents , which are other cells that affect the
current cell.
Number Stored as Text: This means a cell
contains what looks like a value, but the
content is stored as text. Simply verify that
you intend to store the entry as a text entry
not as a value.
Select a cell that contains a formula or one that is
referenced in one or more formulas and choose
Formulas>Formula Auditing>Trace Precedents, or
choose Formulas>Formula Auditing>Trace
Dependents. As you see in Figure 9-28, Excel
displays one or more blue arrows pointing out
dependents or precedents. You see where cell B2 is
a precedent for cells G2, H2, I2, B7, B8, and B9.
Circular: This means that a formula in a
cell refers to the same cell. Excel displays a
circular reference notation in the status bar.
Excel may also display an error box and
display a Circular Reference help window to
assist you in locating the erroneous
formula. In Figure 9-27, the formula in B7 is
trying to add itself to the total, thereby
creating the circular reference.
Figure 9-28
Viewing formula precedents.
Figure 9-27
Circular reference error.
To remove the dependent or precedent tracings,
click Formulas>Formula Auditing>Remove Arrows.
Identifying Formula Precedents
and Dependents
The Formula Auditing features can assist you in
tracing through formulas such as when resolving
worksheet errors. The Formula Auditing features
Search JabSto ::

Custom Search