Identify The Objective Cell and Changing Cells Set Solver to solve the objective cell of B12 on the Home Loan worksheet to the value of 1000. Define the variable cell range as B2:B5. Leave the Solver dialog box open, as you will define the constraints in the next step.
