## Step 1: How to Download & Enable Solver Add-in in Excel.

The solver add-in is included by default in Microsoft Excel but is disabled until the user enables it for use. There are a few easy steps required to enable solver. To enable it, you fist need to click on the file menu and then go to the options tab. Next, the excel options box will come up, click on the solver add-in located under the add-ins heading and make sure it is highlighted in blue. Now, click the go box, which is located in the manage excel add-ins at the bottom of the excel options screen. After you have clicked go the add-ins box will come up. In the add-ins box check the box next to solver add-in, which is located under the add-ins available heading, and then click the okay button. Now that solver has been enabled you will need to know how to locate it for use. Open up excel and go to the data tab and click it, and all the way to the right solver is located under analysis.

## Step 2: Example Function

Excel Solver is used by engineers and mathematicians to solve a large variety of mathematical equations and systems. Solver is equipped with functions that allow users to find the root/solution of an equation. A simple function is given below as an example problem where someone would wish to find the root of the function. The function is: y = 2x^2 + 3x – 4. Solver will solve the equation for 0, i.e. 2x^2 + 3x -4 = 0, as anyone would normally do by hand. In the following illustration, the first step of all excel solutions is to properly define the function that is being solved. The second step is to assign the variable of the function to one specific cell. Assign the variable x to the cell B1 by typing x= in cell A1 and typing nothing in cell B1. Define the function in cell B2 by typing f(x)= in cell A2 and typing =2*B1^2+3*B1-4 in cell B2. Cell B1 plays the part of x in the formula, and by changing the values in cell B1, you will notice that the results of the function will change. The goal is to have cell B1 vary the value of x until the cell B2 (the function) is 0.

## Step 3: Understanding the Solver Parameters Box

## Step 4: Setting the Target Cell and Equal To

Set Target Cell: Solver is asking you to identify the position of the function you wish to solve. In this example the function was placed in the cell B2. After step 2 has been completed go to solver and click on it. The solver parameters dialogue box will pop up. To set the target cell you must use the proper symbols that excel understands, you cannot type in B2. To set the target cell correctly you must type in $B$2.

Set Equal To: The equal to option allows you to identify the operation you wish to carry out with your chosen function. The options that equal to gives are max, min, value. Max would be if you were looking for the maximum value of a function, and min would be used to find the minimum value of a function. The Value option if for you to select the value you want the equation to be solved for. In the given example from step 2, the function is meant to take on the value of 0. Go to equal to, then select value of: and type 0 in the box next to it.