Young Wise and WealthyYoung Wise and Wealthy

Glossary

Circular reference

A formula loop that a spreadsheet cannot resolve in one pass. In a debt schedule, interest depends on average debt, average debt depends on cash flow, and cash flow depends on interest. Fixes are iterative calculation with a circuit breaker, or an interest calculation on beginning balances that avoids the loop.

Related terms

All terms