Can solver do this?

  • Thread starter Thread starter Keith74
  • Start date Start date
K

Keith74

Hi All

I have a list of 32 numbers some of which should roughly add up to a
given value, when i say roughly i mean +/- 10.000. Is there any way to
set solver to do this or does it need some VBA (not a problem, just
point me in the right direction) solution?

Cheers

Keith
 
Thanks Peo

And for the sake of anyone else trying this, you can adjust the limits
of the acceptable return value by changing the tolerance, just click
"Options" on the "Solver Parameters" dialog.
 
Back
Top