New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Multiple constraints on solver

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Multiple constraints on solver

Postby namrata23 » Fri May 19, 2017 2:13 am

In excel solver,i need a variable to either be zero or lie between 50% of max to 100%. i.e it should not lie between 0 to 50% but can be zero. how to add a constraint like this?
  • 0

namrata23
Rookie
 
Posts: 1
Joined: May 19, 2017
Reputation: 0
Excel Version: 2013

Re: Multiple constraints on solver

Postby Don » Tue May 23, 2017 9:31 am

Hi namrata, this forum is closing soon, please ask all future questions on the forum at https://www.teachexcel.com/talk/microsoft-office
  • 0

Don
Moderator
 
Posts: 733
Joined: Dec 4, 2011
Reputation: 2
Excel Version: 2010


Return to General Excel Questions

Who is online

Users browsing this forum: Google [Bot] and 2 guests