+ Reply to Thread
Results 1 to 3 of 3

Need Help in setting constraint for excel solver

  1. #1
    Registered User
    Join Date
    07-23-2017
    Location
    Peoria, USA
    MS-Off Ver
    2016
    Posts
    38

    Need Help in setting constraint for excel solver

    Dear All,

    I am working on an optimization problem, which I have attached here ( sheet 3 of the attached excel sheet). I have modelled the problem, and getting solutions. However, I want to put constraints so that my solver does not return value between 1 to 9. In other words, if decision variable is not 0, it should be greater than 10. Please help me in writing that constraint.

    Thank You

    Pras
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,676

    Re: Need Help in setting constraint for excel solver

    Is it the formula in L16?

    If so, you can use this:

    HTML Code: 
    =IF(SUM(K4:L4)-SUM(K14:L14)=0,0,MAX(10,SUM(K4:L4)-SUM(K14:L14)))
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane

  3. #3
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Stockholm, Sweden
    MS-Off Ver
    Excel 2003, Excel 2007 & reluctant Excel 2010 user
    Posts
    4,599

    Re: Need Help in setting constraint for excel solver

    Not sure how to set a general constraint like that i.e. value should either be 0 or greater than 10. Bit for you uploaded sample where G13=1 I just added a constraint

    Please Login or Register  to view this content.
    and this was the result

    Constraint_solver.jpg

    Alf

+ 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. [SOLVED] Excel Solver Less Than or Equal To Constraint
    By shoulddt in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-04-2018, 02:53 PM
  2. Excel Solver Constraint Help
    By BauceArj in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-14-2014, 08:47 PM
  3. Solver Help: Setting a Constraint to Allow Two Values
    By Schooch47 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-23-2014, 09:05 PM
  4. [SOLVED] Excel Solver Constraint Question
    By Verna in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-19-2012, 04:33 PM
  5. Setting up Solver constraint
    By Jstewart304 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-23-2012, 01:36 PM
  6. Excel Solver- Ratio Constraint
    By Patriot393 in forum Excel General
    Replies: 1
    Last Post: 06-12-2011, 08:55 PM
  7. Excel Solver: Constraint Specification
    By tonisama in forum Excel General
    Replies: 6
    Last Post: 11-16-2010, 05:00 PM

Tags for this Thread

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