Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Mundelein, Illinois, USA
    Posts
    198
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
    Thanks,

    C DeWitt

  2. #2
    Star Lounger
    Join Date
    Jun 2001
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Mundelein, Illinois, USA
    Posts
    198
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
    Thanks,

    C DeWitt

  4. #4
    Star Lounger
    Join Date
    Jun 2001
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Mundelein, Illinois, USA
    Posts
    198
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
    Thanks,

    C DeWitt

Posting Permissions

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