Constraints in Excel Solver

D

Donna

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?
 
T

Tushar Mehta

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
 
Top