How do I correct a complex circular reference?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a circular reference in cell L12. The formula in the cell is:
=sum(L8:L11).
The result in L12 is used by about 8 other cells to make decisions. The cell
computes how many contracts to initiate based four different formulas in
cells 8:11.

Thank you for any clues as to how to resolve the conflict.
 
Something almost has to be reffering to that cell to get some data that you
are summing.

Try Tools->Formula Auditing and look at the precedents and more importantly
the dependents for that cell. Trace you logic and make sure none of those
8-11 are there because of a formula utilizing L12
 
Back
Top