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

formula.

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