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)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgEgBDG041yLhB2gPtD2BviOxpMn655LIWBQUbCO9Mhks2wQhOcbkZ2BOSIOojYmTd9fm7iZ0OjehXEjV2fNbWAlrZxmVBz9HjK2cwp6XAIzlc8C8lDUHpdfVo_hteeuTl9xjZ34w/s320/ScreenHunter_001.jpg)
Then, we all can live with circular references.
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)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgEgBDG041yLhB2gPtD2BviOxpMn655LIWBQUbCO9Mhks2wQhOcbkZ2BOSIOojYmTd9fm7iZ0OjehXEjV2fNbWAlrZxmVBz9HjK2cwp6XAIzlc8C8lDUHpdfVo_hteeuTl9xjZ34w/s320/ScreenHunter_001.jpg)
Then, we all can live with circular references.
Labels: tips
Post a Comment
<< Home