Constrint Value List??? (2000/9.0.3821 SR1)

Topic

New Reply

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

Reply | Quote

Replies

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote