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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to slove: Circular Reference Warning 1
Circular Reference 1
Circular reference 3
Circular Reference quits 3
Circular reference toolbar not working 3
Please help with SUM formula dependent on results of other cells 2
Array to Multiple Arrays 3
How do you initialize the values in a circular reference? 2

Back
Top