Step 8: Once you click on the ADD item, it will open the below dialogue box. Click on ADD option in the Solver dialogue box. Remember our criteria initially we stated. In this example, we need to change the variables X & Y, and these cell values are in B1:B2. Step 6: Now, in By Changing Variable Cells: select the cells you want to change the values to get the sum of 50. In this case, X + Y should be equal to 50.
Step 5: In the To: section, select Value of and type 50 as the value.
In this example, the cell we want to change is cell B3. Step 4: In the Set Objective, give a link to the cell that we want to change. Here we need to set our objective, give many criteria’s and solve the problem. Step 3: Once you click on Solver, it will open the below dialogue box.
The SUM function adds those two cell values and gives the sum. As dummy data, I have mentioned 1 for both X & Y variables. Step 1: Write a simple equation in an excel sheet. You can download this Solver tool Excel Template here – Solver tool Excel Template Example #1Īs I have explained at the start, we will do the X + Y = 50 calculation to start our SOLVER journey in Excel.
