Define and solve a problem by using Solver - Microsoft Support
Put simply, you can use Solver to determine the maximum or minimum value of one cell by changing other cells. For example, you can change the amount of your projected advertising budget and see …
Using Solver to schedule your workforce - Microsoft Support
Start using Solver to schedule your workforce in Excel. Learn how to use Excel's Solver add-in to create a staffing schedule based on your settings.
Load the Solver Add-in in Excel - Microsoft Support
The Solver Add-in is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel. To use the Solver Add-in, however, you first need to load it in Excel.
Using Solver to determine the optimal product mix
Oct 14, 2025 · This article discusses using Solver, a Microsoft Excel add-in program you can use for what-if analysis, to determine an optimal product mix. How can I determine the monthly product mix …
Using Solver for capital budgeting - Microsoft Support
You set up Solver to use a range of binary changing cells by adding a constraint—select the changing cells you want to use and then choose Bin from the list in the Add Constraint dialog box. With this …
Switch between various sets of values by using scenarios
The Solver add-in is similar to Goal Seek, but it can accommodate more variables. You can also create forecasts by using the fill handle and various commands that are built into Excel.
Calculate multiple results by using a data table
You can use the Excel Solver add-in to find the optimal value for a set of input variables. Solver works with a group of cells (called decision variables, or simply variable cells) that are used in computing …
Use Goal Seek to find the result you want by adjusting an input value
If you know the result you want from a formula but aren't sure which input is needed to get that result, use Excel's Goal Seek feature.
Solver in Excel for Windows may not work properly with a certain ...
When a policy is configured to prevent Excel from running Excel 4.0 (XLM) macros, the Solver and Analysis ToolPak add-ins will not function properly. Functionality may be missing, and results may …
IRR function - Microsoft Support
Microsoft Excel uses an iterative technique for calculating IRR. Starting with guess, IRR cycles through the calculation until the result is accurate within 0.00001 percent.