Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is this possible? (Circular reference?) | Excel Discussion (Misc queries) | |||
Circular Reference | Excel Discussion (Misc queries) | |||
'circular reference' | Excel Discussion (Misc queries) | |||
how to: circular reference | Excel Worksheet Functions | |||
what is the correct syntax for an allowable circular reference? | Excel Discussion (Misc queries) |