formulaA sequence of values, cell references, names, functions, or operators in a cell that produces a new value from existing values. A formula always begins with an equal sign (=).
refers to the cell that contains the formula, either directly or indirectly, Excel
creates a circular reference. For example, if you enter a formula in cell A1, such as
can’t successfully calculate a result because the formula in A1 depends on the cell A1 itself. Because Excel can’t resolve this circular reference, 0 is displayed in the cell. Excel returns 0 in a cell when it encounters a circular reference.
Do any of the following:
Locate and remove a circular reference
Make a circular reference work by changing the number of times Excel iterates formulas