iterative calculations

Question

Level 1

4 points

iterative calculations

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?
Thanks

CF

mac book pro 15", Mac OS X (10.6.6)

Posted on Mar 4, 2011 12:52 PM

Reply

Answer 1

Badunit

Level 7

31,341 points

Mar 4, 2011 4:33 PM in response to cfow

Maybe this thread will help:

http://discussions.apple.com/thread.jspa?messageID=11503732&#11503732

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.

Reply

Answer 2

KOENIG Yvan

Level 8

41,845 points

Mar 4, 2011 1:16 PM in response to cfow

cfow wrote:
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

Reply