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

Chapter 5. Troubleshooting Formulas > Fixing Circular References

Fixing Circular References

A circular reference occurs when a formula refers to its own cell. This can happen in one of two ways:

  • Directly—The formula explicitly references its own cell. For example, a circular reference would result if the following formula were entered into cell A1:

    =A1+A2
    
  • Indirectly— The formula references a cell or function that, in turn, references the formula's cell. For example, suppose that cell A1 contains the following formula:

    =A5*10
    

    A circular reference would result if cell A5 referred to cell A1, as in this example:

    =SUM(A1:D1)
    

PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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