Circular reference warning — what to do
What you see
- Excel or Sheets warns about circular references
- Cell depends on its own result
Common causes
- Formula includes the cell it lives in
- Two cells point at each other
How to fix it
- Remove the cell address from its own formula
- Break the loop by using a different helper cell
- Enable iterative calculation only if you intend it