Solver is an add-in that is provided with Excel and used to perform “what-if” analyses by providing alternative answers to a formula in a cell based on values you pass to the formula from other cells in your workbook. Show Enable the Solver Add-in
OR
Note: If the Developer tab is not visible in the Ribbon, you’ll need to add it first.
The Solver add-in now appears in the Data tab in the Ribbon. Create a Solver ExampleSet a Cell to a Specific ValueConsider the following worksheet:
In the sheet above, you need to break-even in Month Number 1 by setting cell B14 to 0 by amending the criteria in cells F1 to F6.
The new scenario is available in the Scenario Manager which can be access in the Ribbon by selection Data > What-If Analysis > Scenario Manager. Get the Maximum Value in a CellConsider the following worksheet:
You wish to make as much profit as possible in selling your fruit. However, you only have 15 bananas and 6 mangoes available, and you need to sell a minimum of 15 apples, lemons, and oranges. In total, you may only sell 100 pieces of fruit.
Since oranges have the highest unit price, Solver raises the number of oranges you need to sell to maximize your profits within the constraints you set. Solve for a Variable in Google SheetsGoogle Sheets allows you only to solve for a single variable and not the multiple variables that Excel allows with the Solver add-in. To do this, you need to install the Goal Seek add-in into Google Sheets. If you don’t already have this add-on installed, see: How to Add Goal Seek to Google Sheets. Once you have the add-on installed, you can solve for a single variable. To learn how to do this, see How to Automatically Vary the Contents of a Cell in Excel and Google Sheets. How do you activate Solver?Load the Solver Add-in in Excel. In Excel 2010 and later, go to File > Options. ... . Click Add-Ins, and then in the Manage box, select Excel Add-ins.. Click Go.. In the Add-Ins available box, select the Solver Add-in check box, and then click OK.. Why Solver is not working?This could be due to the fact your ActiveX settings are disabled and for Solver to work, they need to be enabled. In the Ribbon, select File > Options and then (1) select Trust Center and (2) Trust Center Settings.
|