Page 200 - Trackpad 402_Class-X_Final
P. 200
• Formula cell: In the Formula cell, we can enter the reference of the cell which contains the formula. It contains
the current cell reference. We can click another cell in the sheet to apply its reference to the text box.
• Target value: It specifies the value you want to achieve as a new result.
• Variable cell: It specifies the reference for the cell that contains the value you want to adjust in order to
reach the target.
Step 3: Change the values of Default settings as given below:
Formula cell: $C$9
Target value: 94
Variable cell: $C$5
Step 4: Click on OK button. The given dialog box will be displayed with the message Goal Seek was successful.
Step 5: Click on Yes to change the cell C5 with the new value predicted 96 that will make the percentage 94% of the
weekly test.
The worksheet with the new changes in the predicted marks for maths to get the desired percentage is shown below:
USING SOLVER
Solver is another What-if Analysis Tool of OpenOffice Calc. It is the next advanced form of Goal Seek. In case of Goal
Seek you get the desired result by changing one variable whereas in case of Solver you get the desired result by
changing the multiple variables. It helps you find out the best possible combinations of the multiple variable values
for the maximum or minimum desired result. It works on rules applicable for different variables used in the formula:
• The variables in the formula should be greater than, less than or equal to the desired value entered in Solver.
• If you do not want the variable to change then the value of the variable should be equal to the desired value entered
in Solver.
• If you want the variable to change then you can set the rule that the variable cannot be either bigger than another
value or bigger than the desired value entered in the Solver.
200 Trackpad Information Technology-X

