Excel iterative calculation and circular reference
To understand what is Excel iterative calculation, you should first understand what is circular reference.
Circular reference happens when you type a formula in one Cell which refers to another Cell, but that Cell also refers back to the Cell.
For example,
Cell A1: = 1+A2
Cell A2: = 1+A1
The above formula refer to each other, this is called circular reference (refer to each other forming a circle). The formula will fail and the be...
Read More