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?
 
Back
Top