Quizzes & Puzzles2 mins ago
Excel: solver
2 Answers
How do you use the solver in Excel? I want to use Max and Min.
Answers
1 to 2 of 2
Best Answer
No best answer has yet been selected by candice. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
If you use Office Assistant, the answer to your query can be found by typing 'solver' and clicking Search. From the resulting options, select 'Define and solve a problem using solver'. Follow the instructions there.
Here's a summary of the instructions -
1. Select 'Solver' from the Tools' menu.
2. Make sure your target cells contain a formula.
3. Enter a name or cell reference for the target cell in the 'Set Target Cell' box.
4. If you want the largest possible target cell click Max, and click Min for the smallest.
5. Enter the reference or name for your adjustable cells in the 'By Changing Cells' box.
6. If you want Solver to propose the adjustable cells click 'Guess'.
7. Click Solve.
8. In the Solver Results box, click Keep Solver Solution. This will keep the solution values on the worksheet.
If you can follow this, you're far more adept with spreadsheets than I am. Sorry if this doesn't make much sense, but it's way beyond my skills with Excel.
Here's a summary of the instructions -
1. Select 'Solver' from the Tools' menu.
2. Make sure your target cells contain a formula.
3. Enter a name or cell reference for the target cell in the 'Set Target Cell' box.
4. If you want the largest possible target cell click Max, and click Min for the smallest.
5. Enter the reference or name for your adjustable cells in the 'By Changing Cells' box.
6. If you want Solver to propose the adjustable cells click 'Guess'.
7. Click Solve.
8. In the Solver Results box, click Keep Solver Solution. This will keep the solution values on the worksheet.
If you can follow this, you're far more adept with spreadsheets than I am. Sorry if this doesn't make much sense, but it's way beyond my skills with Excel.
Hi thanks for attempting to answer the Solver query, Jonathan. I, however, had already turned to the Office Assistant for help. The office assistant gives the steps but I do not under the results !! Why are my results so large ? What constraints / factors did it use to calculate its results ? Is there anyone on that side who uses Solver and can help with the interpretation of the results ?
Thanks Candice
1 to 2 of 2
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.