Forum Discussion
Circular Reference get the Current Iteration value and number of iterations to converge
I have a spreadsheet that is using a circular reference to solve a thermodynamics problem under varying conditions. 99.9% of the time, it converges to the solution relatively quickly. However, for ...
I have the same urge. A large complex sheet with iterations that I want to run in several scenarios (data tables). But I have no way of telling if any of the scenarios failed to converge.
If I could just get a flag that told me wether the iterations converged (TRUE/FALSE), I would be happy. This should be easy for the Excel engine to provide, but I have yet searched in vain.
If I could just get a flag that told me wether the iterations converged (TRUE/FALSE), I would be happy. This should be easy for the Excel engine to provide, but I have yet searched in vain.
Hi,
I think recursive lambda should be enough to handle simple root searching scheme such bi-section root searching.
I use Excel's built-in NORM.DIST function as an example.
e.g Finding x s.t NORM.DIST(x, 0,1, TRUE) = y use bi-section.
