Page 226 - TP_IT_V1.0_C10_flipbpookl
P. 226
USING SOLVER
Solver is another What-if Analysis Tool of LibreOffice 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.
Let us take an example to understand the concept of solver. Suppose, the unit test marks of each subject of
Devesh, a student of Class 10, are:
Subject Marks
English 94
Hindi 97
Maths 82
Science 89
Social Studies 87
Information Technology 89
Now, we want to calculate Devesh’s percentage marks using Solver with the following criteria:
• Math marks is greater than or equal to 95
• Science marks is less than or equal to 90
• Social Studies marks is less than or equal to 92
• Information Technology marks is less than or equal to 95
To use solver, perform the following steps:
Step 1: Enter data in a sheet that is used to calculate the total marks and percentage.
Step 2: Type the =SUM(B2:B7) formula in cell B8 to calculate total marks and press Enter key.
Step 3: Type the =(B8/600)*100 formula in cell B9 to calculate percentage and press Enter key.
224 Trackpad Information Technology (Ver. 1.0)-X

