If you can't live without circular references, just turn on the iteration.
cell A + cell B = cell C
while:
cell B = cell C - cell A
In Excel, cell B and cell C are the sources of circular references.
However, to make the calculation work as is, the iteration must be set on as the image below. (Tools>Options)
Then, we all can live with circular references.
notes
- This service has been inactive since 2010 as my new role in TM1 consulting.
- Please disregard any commercial offers as this website has been archived and transformed into a blog rather than a commercial website.
- Please contact me for more info in BI and Financial Modelling consultancy.
0 comments:
Post a Comment