 Tweet

# 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.    