3 ms·
Goal seek does this. It is a built in capability.
by granto 6y ago
Goal seek does this. It is a built in capability.
- pottertheotter 6y agoBut you have to use it manually. You could make a macro and automate it, but it would be nice to have function that is built-in.
- twobitshifter 6y agoBoth 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.