Forum Discussion
jmunozhoneywell
Apr 10, 2020Copper Contributor
Iterations not working
I have enabled iterations and set the maximum iterations to 1000 and the maximum change to 0.001. I have the workbook calculation option set to automatic. If I change a value in the path of the circular reference, the formula does a single calculation without iterations. The solution is not the right answer.
5 Replies
Sort By
How did you know how many iterations were done before formula returns the result?
- jmunozhoneywellCopper Contributor
SergeiBaklan The formula did not return the correct answer. I'm trying to perform the calculation explained in the following video: https://www.youtube.com/watch?v=rWS2mUZfd1s
I followed the instructions exactly and I double checked and triple checked all the formulas. My answer is not the same as shown in the video. See attached spreadsheet. The solution in cell L2 is supposed to be 8.67.
The person that recorded the video used 10 iterations. I tried that and then I increased it to 100 and neither worked.
If you change the formula in L2 from
=(G2+C2+K2*H2)/(K2+G2)
on
=(G2*C2+K2*H2)/(K2+G2)
as it is on video, you'll have the same result as in sample. 10 iterations is enough.