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.