Solver

  • Thread starter Thread starter Marian
  • Start date Start date
M

Marian

Hi, I would like to use Solver, but it is the first time I've been
working with it.

My problem: I have a group of 6 numbers, which are counted at the bottom:

6,43
12,11
2,31
42,84
50,29
27,95

141,93

I wanted Sovlver helped me to decrease the number 141,93 to 41,93 by
changing all the numbers above, but it should use the same percentage at
every number. How to adjust the Solver?

Thanx

Marian
 
As regards using solver, its just a case of changing the way you've
structured the problem - use a factor to multply each number, and solve
where that factor is the variable.

However, in this case can't you just multiply each number by 41,93/141,93
and not even bother with solver?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007: Help creating a macro that will run Solver? 3
precision in solver 4
Solver not found 1
what does error message "too many adjustable cells" mean in solver 1
Using Solver - integer solution 3
Solver Error - an unexpected internal error has occurred 1
Random Numbers 4
Will Solver do the job? 7

Back
Top