Module VI· Circular References & IterationIntermediate
Question

What is a circularity switch, and how do you build it?

Answer

A circularity switch lets the model toggle between circular and non-circular logic. Example: if switch is ON, calculate interest on average debt; if OFF, use beginning debt. Build with an IF statement referencing a control cell. This allows auditing without iteration and final output with more accurate circular calculations.