+ Reply to Thread
Results 1 to 2 of 2

Solver - Evoloutionary, how to apply upper and lower bounds

  1. #1
    Registered User
    Join Date
    12-19-2012
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2010
    Posts
    18

    Solver - Evoloutionary, how to apply upper and lower bounds

    Hi Guys,

    I'm trying to use the Evolutionary function on Solver. From my reading I believe it can Max a cell even if it, or the constraints have 'if' function feeding into them. When i try to run it I get the error

    "
    All variables must have both upper and lower bounds.

    The Evolutionary Engine and Multistart option require that you
    specify both and lower bounds on all the Variable Cells.
    "

    The problem is I can figure out how to apply the upper and lower bounds to the Variable Cells.
    I'm sure it something easy, I feel silly asking.

    Thanks Guys,

    Simon

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: Solver - Evoloutionary, how to apply upper and lower bounds

    A sample workbook would help a lot.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 08-30-2014, 01:41 PM
  2. [SOLVED] Determine if a cell value is within upper and lower bounds?
    By Darksabre in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-03-2013, 01:30 PM
  3. [SOLVED] Multiple if statements with upper/lower bounds
    By crail5 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-15-2013, 01:25 AM
  4. Using MIN on range with upper and lower bounds
    By MWMike in forum Excel General
    Replies: 3
    Last Post: 12-13-2011, 03:13 PM
  5. [SOLVED] How to fix lower and upper bounds for data
    By charter_SKR in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-10-2006, 12:35 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1