Hi All,
I have a linear programming problem with 4 constraints and I only require 3 of the constraints to be fulfilled, how would I input this into Excel Solver? Would there be an equation for this?
Thanks
Hi All,
I have a linear programming problem with 4 constraints and I only require 3 of the constraints to be fulfilled, how would I input this into Excel Solver? Would there be an equation for this?
Thanks
With solver you define a min or max cell, a number of adjustable cells and a number of constraints, so he'll find a solution, I don't see the problem.
Please add an example.
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
You should add a set of binary decision variable to control the constraints.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks