Forum Discussion
Excel circular reference
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.
