![how to add solver excel 2016 how to add solver excel 2016](https://technowikis.com/sites/technowikis.com/uploads/152/15228566743087800334.png)
Click Change and then make your changes, or click Delete.In the Solver Parameters dialog box, click the constraint that you want to change or delete.You can change or delete an existing constraint by doing the following:.Note: You can apply the int, bin, and 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.If If you choose = for the relationship 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 and the constraint.In the Cell Reference box, enter the cell reference or name of the cell range for which you want to constrain the value.In the Solver Parameters dialog box, click Add.In the Subject to the Constraints box, enter any constraints that you want to apply by doing the following:.You can specify up to 200 variable cells.
![how to add solver excel 2016 how to add solver excel 2016](https://www.solver.com/sites/default/files/panelmanufacturingsolver3.jpg)
![how to add solver excel 2016 how to add solver excel 2016](https://4.bp.blogspot.com/-OkFVZy0iHLY/WILtYZQndTI/AAAAAAAAAYw/Zz9xAnr5R9IHptSk6_OPf5dE1cmf4yKqwCLcB/s1600/Desktop%2B1-15-2017%2B10-17-07%2BPM-738.png)
The variable cells must be related directly or indirectly to the objective cell. Separate the non-adjacent references with commas. In the By Changing Variable Cells box, enter a name or reference for each decision variable cell range.If you want the objective cell to be a certain value, click Value of, and then type the value in the box.If you want the value of the objective cell to be as small as possible, click Min.If you want the value of the objective cell to be as large as possible, click Max.