Forum Discussion
Iterations not working
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.
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.
SergeiBaklan I'm so embarrassed. You have no idea how many times I've looked at this formula and compared it to the video and still didn't see the error. Thank you so much for taking a look at this and helping me with a solution. I wish I could buy you a beer to show my appreciation. Have a great day.
jmunozhoneywell , no problem, that could happen with everyone. Have a nice weekend!