![]() Since the supplied range also includes A7 cell (in which the result needs to be populated) so it creates an endless loop as Excel just keeps on adding the new value in cell A7, which keeps on incrementing. But inside the SUM function, we have passed the range as A1:A7. In our example, there are a few numbers in column A and we are trying to calculate their sum using the SUM function in A7 cell. This endless reference loop, if not stopped will keep changing the cell's value every time.įor quick understanding, here’s an example. In simple terms, a circular reference happens when a formula references back to its own cell directly or indirectly, creating an endless loop of calculations. If this statement seems a bit confusing, don’t worry by the end of this tutorial it will start to make sense. A circular reference occurs when you end up having a formula in a cell – which in itself uses the cell reference (in which it’s been entered) for the calculation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |