Constraints in Excel Solver

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want the constraints on the changing cells to be that they can only change
to 0 or not change at all. How can I do this?
 
Use a (dummy) binary variable as the 'by changing cell'. For the value
used in the computation use the cell containing the binary value
multiplied by the value of the original 'by changing cell.'

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Solver constraints 1
Solver 4
Excel Solver violates constraints 0
I need to know how to use the solver 1
Is there a single function that duplicates Solver? 1
How accurate is SOLVER? 1
Solver constraint/Formula 10
Formula for Solver 1

Back
Top