[granto]

Goal seek does this. It is a built in capability.

[twobitshifter]

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/

Here’s an example from chemical engineering of iterative calc. 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.

[pottertheotter]

But 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.