In this article, we will learn about circular reference.
Circular reference can be a formula that refers to its own cell value, or refers to a cell dependent on its own cell value.
In simple words, the cell in which formula is being calculated & the cell itself is also included or part of the range then a circular reference warning message will appear. It might cause for the incorrect calculation by the formulas.
Let us take an example:
If above shown error message regarding circular reference pops up while adding formulas, then you might have created circular cell reference unknowingly. You can track & then remove the incorrect reference & it will remove the circular reference.
To track circular reference, follow the below steps:
Below you can find more examples:-
How we can see circular reference
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.