| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Constraints in Excel Solver
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 , 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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ratios in Excel Solver | Excel Discussion (Misc queries) | |||
| Problem with Solver and Integer constraints | Excel Worksheet Functions | |||
| Display form from an VB application in Excel | Excel Discussion (Misc queries) | |||
| Excel: Solver | Excel Worksheet Functions | |||
| Excel formula with date constraints | Excel Discussion (Misc queries) | |||
Threaded Mode
