Hi,
with me always comes this error message because of the missing iterative calculation
"This formula can not refer to his own cell or depend on some other formula did Refers To did cell"
Is there a simple possible solution for this problem?
greet
Dennis
Hi Dennis,
A formula can not refer to its own cell. It may be possible to iterate across a series of cells. Please reply with what you are trying to do.
Regards,
Ian.
Iterative calculations is not a feature of Numbers. When Applescript is again supported, you will be able to do iterative calculations with a script. Excel can do iterative calculation but it is not the default behaviour of Excel or any spreadsheet. It also has Solver and Goal Seek which I think do iterative calculations. With a normal spreadsheet you can sometimes get there as Yellowbox said, by repeating your calculations across a series of cells where each result feeds into the next set of calculations.
To iterate you can "sweep" a value in one column that is the input to the function you want to iterate. OR you can use a stepper or slider to change the value and watch the result.
Iterative calculation
