4234 Views 2 Replies Latest reply: Mar 4, 2011 4:33 PM by Badunit
i have a question as i am very new to numbers (excel too for that matter) I imported a model from excel that has circular references until i enable iterative calculations.( to do it in excel: Select ALT T, O and then on the 'Calculation' tab check the box that says enable iterative calculation.) how would i do this in numbers?
For Numbers, a circular reference is an error, no way to change that.
Yvan KOENIG (VALLAURIS, France) vendredi 4 mars 2011 22:15:16
Maybe this thread will help:
The description I gave said "the formula" is in cell B4. It does not have to be "the formula", it has to be the result of the iteration, which might be based on numerous formulas scattered throughout the Numbers document.