Excel Tips: How to Solve Circularity Errors With Iterations
Tutorial: How to solve circularity issues using iterations
Circular references are any references with in a formula that depend upon the results of that same formula. For example, a cell that refers to its own value or a cell that refers to another cell which depends on the original cell’s value both contain circular references.
Here is an example of Circular reference, I am adding different fruits from my excel sheet, by using formula of “=SUM(number1, number2….)”, I added from B3 to B7, please note that B7 is the cell where I am entering the formula.
When I press enter to calculate the sum I’ll get the circular reference error, and the answer will be shown as “0”
To correct this error, you need to know that where exactly the circular reference is, to find the circular reference, go to “Formula” menu, click on the “Error checking” arrow and choose “Circular References”, you will know where exactly the error is.
The circular reference is showing in $B$7 i.e. in B7 cell, press F2 in B7 cell and correct the formula by entering B6 instead of B7.
By pressing “Enter” you will get the correct answer and there will be no error of Circular Referencing.