How to use Goal-Seek or Solver automatically

[JnJCHC]

Hi,

I am trying to use Goal Seek or Solver to solve a margin equation but since this is variable due to different prices I wanted to find out how I can make Goal Seek or Solver do it automatically?

Is there a way to use an If statement to do this?

Thank you in advance for your help.

 

[Biz]

It is possible need more information. Can u give an example?