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
   221   222   223   224   225   226   227   228   229   230   231