3 ms·
Both are built in but goal seek is limited in what can be done in the loop, and doesn’t use the in between steps in the seek. Here’s a simple excel for loop wi
by twobitshifter 6y ago
Both are built in but goal seek is limited in what can be done in the loop, and doesn’t use the in between steps in the seek.
Here’s a simple excel for loop with iterative calculation.
https://access-excel.tips/excel-iterative-calculation/ https://access-excel.tips/excel-iterative-calculation/
Here’s an example from chemical engineering of iterative calc.
https://www.aiche.org/chenected/2017/03/excel-tip-6-use-excels-iterative-solver-close-recycles-and-other-circular-calculations https://www.aiche.org/chenected/2017/03/excel-tip-6-use-exce...
There’s also an evolutionary and linear solvers for optimization problems, but that’s again something that’s more of an add in.