Constraints in Excel Solver

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

In article <EEE1B39D-F633-40EE-A657-7F6724E05FED@microsoft.com>,
Donna@discussions.microsoft.com says...
> 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?
>
>
>