Formula guide · Excel and Google Sheets · Updated May 13, 2026
Circular Reference in Excel or Google Sheets
Fix circular reference warnings when a formula refers back to its own cell or dependent result.
Quick Answer
A circular reference means a formula depends on itself directly or indirectly, so the spreadsheet cannot calculate normally.
Copyable Formula
Do not put =A1+1 inside A1.Syntax
Trace the formula path and remove the self-reference.Excel and Google Sheets
Worked Example
| Symptom | Likely cause |
|---|---|
| Circular warning | Formula points to itself |
| Unstable result | Cells depend on each other |
| Unexpected zero | Iterative calculation setting |
Result: Removing the self-reference lets the spreadsheet calculate the formula normally.
Steps
- Identify the cell named in the circular reference warning.
- Check whether the formula includes its own cell.
- Trace dependent formulas if the loop is indirect.
- Move intermediate calculations to helper cells when needed.
Common Mistakes
- Turning on iterative calculation without understanding the loop.
- Fixing only the visible formula while another cell still depends on it.
- Building totals inside the same range being totaled.
Excel vs Google Sheets Notes
The core idea works in both Excel and Google Sheets, but separators, function availability, and array behavior can vary by account, locale, and version.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.