Excel circular reference

Copper Contributor

I have a Mac OS and I need to enable iterative equations on my excel to be able to apply a circular reference equation. After googling the steps that I need to go through are File>Options>Formulas>Iterative Functions. However, I cannot find the "Options" tab. How can I enable iterative functions?

1 Reply

@yomnashaker Excel, Preferences..., Calculation, Use Iterative Calculation.

Screenshot 2021-12-23 at 07.30.22.png