Excel Solver - Multiple By Changing Variables

Hi All,

Attached is a document where I know what I want to do, but have no idea how to get Solver to do it.

For the "Q7)" tab, for example, I need to use Solver to get the minimum value of $I$52 by changing $E$52 (which has a constraint that it equals 282.1) and also $I$52 is less than or equal to 12.

Is someone please able to help me with this? Am I able to rearrange it in some way that will allow me to do this without too much hassle?

Thank you.

Your setup for the problem does not make sense. You wish solver to minimize cell I52 by changing the cell value of E52 but you also say the E52 should be equal to 282.1???

First of all the target cell must be related to the cell to change i.e. cell I52 must contain a formula that will change the value of it when changing the value in cell E52.

The setup when you have fixed these problems would look like this:
solv_setup.jpg

Depending on the problem linear or nonlinear the proper solver engine should be selected, for nonlinear problems use GRG nonlinear or Simplex LP for linear problems.

Alf