How do I correct a complex circular reference?
 

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.

How do I correct a complex circular reference?
 

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

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Ole Tom" wrote:

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.

How do I correct a complex circular reference?
 

You may want to try Stephen Bullen's utility:
http://www.oaltd.co.uk/Excel/Default.htm
Look for FindCirc.zip

Ole Tom wrote:

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.

--

Dave Peterson