• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 5. Working with Formulas and Functions > Recognizing Circular References

Recognizing Circular References

Type the formula you want to use in your calculation. For example, type =SUM(B4+C4+D4+E4+F4) and press Enter.

Excel displays an error message, notifying you that the formula contains a circular reference. Click OK.

Click on the resultant cell, press F2 on the keyboard, and retype your formula—in this case, =SUM(B4+C4+D4+E4)—and press Enter.

The error is fixed because the result cell no longer is in the calculation.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint