Can solver do this?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Keith74 - 25 Jul 2007 15:49 GMT

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

Reply to this Message

Peo Sjoblom - 25 Jul 2007 16:21 GMT

Try this method

http://tinyurl.com/27eklq

Signature

Regards,

Peo Sjoblom

> Hi All
>
[quoted text clipped - 6 lines]
>
> Keith

Reply to this Message

Keith74 - 25 Jul 2007 17:08 GMT

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.

Reply to this Message

Rate this thread: