Problem in solver

[bines53]

Hello friends,

I need help, I need to get a solution which is fourth in the cell M7.

Thank you!

 

[Khalid NGO]

Hi David,

See if it helps:





Regards,

 

[bines53]

Hi Khalid NGO ,

Simple and brilliant !

I have another request, is more complicated for me.

The target cell is J1 ,I have found, are the two values in the cells,F6,G6 ,Give the highest result,in J1.
How to do it with solver ?

Thank you!

 

[Nebu]

Hi:

For solver, you have to define the following:

1. your objective function.
2. your constraints.
3. your decision variables.

Here is a link that explains what each means, once you comprehend this , it will really easy to create a solver solution.

http://www.solver.com/solver-tutorial-defining-model

Note: The solver generally generate 3 reports:

• Answer Report
• Sensitivity Report
• Limits Report

It would be good idea to learn to interpret the results from these reports, if you are planing to use solver for optimization problems.

Your above query is a bit confusing for me, if you can clarify your problem using the above method it would be easier for us to give an appropriate solution.

Thanks