# Thread: Constrint Value List??? (2000/9.0.3821 SR1)

1. ## Constrint Value List??? (2000/9.0.3821 SR1)

i'm trying to use solver to minimize a value with constraints on the changing cells. The constraint is that two of the cells can only be 1,2 or 3 and the other can only be 1, 2 or 4. Is it possible to put a list in of possible values for the cells?

Happy Turkey day!

Thanks

2. ## Re: Constrint Value List??? (2000/9.0.3821 SR1)

Let's assume cell d7:d8 must have 1,2,3 and d9 must have 1,2,4. You can place this in a cell, say G3, which contains a formula:
=AND(OR(D7={1,2,3}),OR(D8={1,2,3}),OR(D9={1,2,4}))
then use solver to make sure G3 is TRUE.
HTH
Bob Umlas
Excel MVP

3. ## Re: Constrint Value List??? (2000/9.0.3821 SR1)

Doesn't this require me to solve for G3? What I need to do is solve for a minimum value in anouther cell (say d10) while constraining d7:d9 to legal values of 1,2,3 or 1,2,4.

Thanks

4. ## Re: Constrint Value List??? (2000/9.0.3821 SR1)

No -- G3 has the requirements built in to its formula. When G3 is true, its contents must be true which are your restraints.

5. ## Re: Constrint Value List??? (2000/9.0.3821 SR1)

I can't see how having this cell on the sheet affects the changing cells, all it does is give a True/False indication of the values in these cells. Making G3 a Boolean constrained cell doesn

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•