Iteration

Google-Sheets

Definition

When enabled, allows formulas to calculate iteratively (useful for circular references).

Example

Setting File → Settings → Calculation to allow iterative calculations lets you use formulas that reference themselves.

Stop Juggling Dashboards. Start Growing Get your data flowing today, free plan available.