Solver is an add-in and not enabled by default. To enable it, head to file/options which will open this window.
Navigate to the add-ins tab and click ‘Go’.
Check ‘Solver add-in’ and click OK. It may take a few minutes to install. Once complete, the solver button will be available under the data tab on the ribbon.
Firstly, you should start with a set of data.
It is important to note that formulas are required for the Solver to work correctly. My example above uses 3 formulas. The 1st multiplying the cars sold by the car price to calculate the income. The 2nd multiplying the cars sold by the manufacturing cost to calculate the total cost. Finally the profit is calculated by taking the income and deducting the total cost.
Next click the solver button to open the solver window.
Now, you must define the following:
To add a constraint, click Add which will show the above window. Select the cell to apply the constraints to. Select the type of constraint and the value. The example above shows that the value of that cell must always be greater than or equal to 5000.
Once all constraints and all other inputs have been added to the solver, click solve to generate a result.
As in the example above, the Profit cell has been changed to £1500 and the cells restricted by the constraints have been kept as whole numbers and equal to £5000.
If you are happy with the solution found, click Ok with Keep Solver Solution selected, if not click cancel and make edits within the Solver window.