Solver

Since this sounds like homework (not that it makes that much difference), I will make a few suggestions, but leave the actual work to you.

I tried several things but I cant get it solved..

Sometimes it is nice to describe what you have tried, what results these attempts gave, and why they are wrong. This gives us some insights into your thought process, and where you are right and where you may be going wrong.

The first question I usually tackle with a question like this is "what is my objective function?" The objective function is the function that I want to maximize, minimize, or find the root of. This is also the cell that will go into the "set target cell" field in the Solver dialog. What have you tried as your objective function?

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.