When the Simplex LP Solving Method is selected, there is no limit on the number of constraints.You can apply the int, bin or dif relationships only in constraints on decision variable cells.To accept the constraint and return to the Solver Parameters dialog box, click OK.To accept the constraint and add another, click Add.A constraint such as A1:A3 <= B1:B3 is shorthand for A1 <= B1, A2 <= B2, A3 <= B3. Use only the dropdown list to select integer, binary or alldifferent – do not type these words. For best performance and best results in Solver reports, use a number, or a reference or name of a cell or cells that contain numbers. In the Constraint box, type a number, a cell reference or name, or a formula.If you click dif, alldifferent appears in the Constraint box.If you click bin, binary appears in the Constraint box.If you click int, integer appears in the Constraint box.Click the relationship ( =, int, bin, or dif ) that you want between the referenced cell(s) and the constraint.You can use a single cell or a cell range, but not multiple ranges. In the Cell Reference box, enter the cell reference or name of the cell range whose value(s) you want to constrain.
0 kommentar(er)
