Function for Goal Seek or Solver

[Oferlander]

Hi, Is there a function (meaning - formula) in which I can use to achieve Goal Seek ?
I refer to a formula, rather that to activate the tool in the tool bar

The same question for Solver

Thanks!

 

[iliace]

I would suggest looking into using iterative calculations, also known as intentional circular references. Unfortunately, these are very open-ended, so it takes some effort to set them up correctly. It is also very possible to get incorrect/undesired results, and as such they are generally difficult to implement.

But, nonetheless, totally doable. Here's a pretty good example: Intentional Circular References | Roy MacLean's VBA Blog