Help with goal seek-ish problem

[annpetren]

Hello,

I have goal seek-ish problem. Think the regular goal seek function:

Set cell A1
To value x
By changing cell B1

What I want to do is based on the same principle how with one additional arguement, see below:
Set cell A1
To value x and minimize cell C1
By changing cell B1

Is this possible? If it is, how do I do it?

 

[Eric W]

Welcome to the Board.

What you need is the Solver add-in. This comes as part of Excel, but it's not enabled by default. Go to File > Options > Add-ins > On the bottom click Go next to Excel Add-ins > check the Solver Add-in > OK.

Now go to the Data tab and on the far right is the Solver button. Try it out, you may be able to figure out how to use it just by looking at it. If not, come back and ask again.

 

[annpetren]

Welcome to the Board.

What you need is the Solver add-in. This comes as part of Excel, but it's not enabled by default. Go to File > Options > Add-ins > On the bottom click Go next to Excel Add-ins > check the Solver Add-in > OK.

Now go to the Data tab and on the far right is the Solver button. Try it out, you may be able to figure out how to use it just by looking at it. If not, come back and ask again.

Thank you, I will look into that.