2 Replies Latest reply: Mar 4, 2011 4:33 PM by Badunit
cfow Level 1 Level 1 (0 points)
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)
  • Level 8 Level 8 (41,780 points)
    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
  • Badunit Level 6 Level 6 (11,380 points)
    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.