Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add Constraint - "Solver:
hello community
can someone please explain to me how to use the "bin" and what does "bin" stands for, is it "binary" - in the Add Constraints dialog box when I use the "Solver" feature in excel. There are five constraints, <= = = Int Bin only the last one, "Bin", which I do not understand what is it use for. thanks community for the kind assistance :) everybody with Good Health :) -- oldLearner57 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add Constraint - "Solver:
oldLearner57 -
"Bin" is typically used to constrain changing cells to binary values: 0 (zero) or 1 (one). - Mike http://www.mikemiddleton.com "tikchye_oldLearner57" wrote in message ... hello community can someone please explain to me how to use the "bin" and what does "bin" stands for, is it "binary" - in the Add Constraints dialog box when I use the "Solver" feature in excel. There are five constraints, <= = = Int Bin only the last one, "Bin", which I do not understand what is it use for. thanks community for the kind assistance :) everybody with Good Health :) -- oldLearner57 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add Constraint - "Solver:
tikchye_oldLearner57 wrote:
hello community can someone please explain to me how to use the "bin" and what does "bin" stands for, is it "binary" - in the Add Constraints dialog box when I use the "Solver" feature in excel. There are five constraints, <= = = Int Bin only the last one, "Bin", which I do not understand what is it use for. thanks community for the kind assistance :) everybody with Good Health :) Bin stays for binary. It should mean that the constraint cell can assume only 0 (false) or 1 (true) value... -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver parameter constraint question | Excel Discussion (Misc queries) | |||
Adding a constraint. | Excel Discussion (Misc queries) | |||
cell value constraint | Excel Discussion (Misc queries) | |||
solver constraint | Excel Worksheet Functions | |||
Definition of integer constraint | New Users to Excel |