Goal seek also covers various optimization / iteration scenarios.
Or solver.
Options exist for iterations and maximum change directly with circular references.
https://bettersolutions.com/excel/formulas/circular-referenc...
Adding in indirect/offset/lookups/indexes etc - I've gotten surprisingly far.
I'm also OK doing VBA BUT the MAJOR downside of VBA - horrendous to share it and got worse over time for security reasons.
Excel without VBA - you can give the "program" to anyone, and almost anyone can use it (and in a pinch change it).