Microsoft Office Tutorials and References
In Depth Information
Working with circular references
If you’re just verifying your figures, press the Esc key to discard the edited formula.
Otherwise, if you press Enter, you replace the selected portion of the formula.
Figure 12-28 Select any part of a formula, and press F9 to convert it to its resulting value.
Note
You also can click the Evaluate Formula button on the Formulas tab to troubleshoot
your workbook models. For more information, see “Evaluating and auditing formulas”
in Chapter 8.
Working with circular references
A circular reference is a formula that depends on its own value. The most obvious type is a
formula that contains a reference to the same cell in which it’s entered. For example, if you
type =C1-A1 in cell A1, Excel displays the error message shown in Figure 12-29. After you
click OK, Excel opens the Help dialog box, which displays a pertinent topic.
Figure 12-29 This error message appears when you attempt to enter a formula that contains a
circular reference.
Search JabSto ::




Custom Search