As Seen on TechCrunch: Finofo Raises \$1.65M CAD!

## How to Use Solver in Excel: Step-by-Step Guide

Solver in Excel is a powerful tool for optimization problems. Follow these steps to use Solver effectively.

#### Step 1: Enable Solver Add-In

1. Click on the "File" tab in Excel.
2. Select "Options" at the bottom of the left-side menu.
3. In the Excel Options dialog box, choose "Add-Ins."
4. In the Manage box, select "Excel Add-ins" and click "Go."
5. Check the "Solver Add-in" box and click "OK."

#### Step 2: Open Solver

1. After enabling the Solver Add-In, you should see a "Solver" option in the "Data" tab or "Analysis" tab, depending on your Excel version.
2. Click on "Solver" to open the Solver Parameters dialog box.

#### Step 3: Set Solver Parameters

1. Set Objective:
2. In the "Set Objective" box, enter the cell reference or formula for the cell you want to optimize (maximize or minimize).
3. Select whether you want to maximize or minimize the objective.
4. By Changing Variable Cells:
5. In the "By Changing Variable Cells" box, enter the cell references or range of cells that contain the variables to be adjusted.
6. Subject to the Constraints:
7. In the "Subject to the Constraints" box, add constraints by clicking "Add" for each constraint.
8. Define the cell reference or formula for each constraint and specify the relationship (<=, =, >=) and the right-hand side value.
9. Options (Optional):
10. Click on "Options" to set additional parameters, such as adjusting the solving method or setting convergence criteria.

#### Step 4: Solve the Problem

1. Once you've set up your parameters, click "Solve" in the Solver Parameters dialog box.
2. If prompted, choose the solving method and click "OK."
3. Solver will attempt to find the optimal solution. If successful, it will show a dialog box with the Solver Results.

#### Step 5: Review Results

1. The Solver Results dialog box displays whether Solver found a solution and provides options to keep the solution, restore original values, or generate a report.
2. Click "OK" to accept the solution.

#### Tips and Tricks:

• In the Solver Options, you can adjust the precision of the solution by changing the "Precision" option.

Multiple Scenarios:

• If you want to explore multiple scenarios, consider using Solver's ability to save different scenarios.