Iteration and Circular Reference

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.

Labels:

Comments:

Post a Comment

<< Home

this tool only works in IE
Calculate Your Power
Your Energy
Your Age Now y.o.
Your after-tax Annual Income
Monthly Expenses
Desired Real Return %
Desired Retirement Age y.o.
Transcendence Ratio %
Your Power
Annual Saving
Power in 5 yrs
Power in 10 yrs
Power @ Retirement
Estate Planning
Charity
>> read Transcendence Power