Page 227 - TP_IT_V1.0_C10_flipbpookl
P. 227

Step 4:  Select the Tools   Solver option from the Menu bar.






























                         The Solver dialog box open.
                 Step 5:  Change the values in the Solver dialog box as given below:
                         Target cell: $B$9
                         Optimise result to: Value - 94

                         By changing cells: $B$4:$B$7
                         Cell reference: $B$4 >=  95
                                                    $B$5 <=  90
                                                    $B$6 <=  92

                                                    $B$7 <=  95
                 Step 6:  Click on Solve button.
































                         The Solving Result dialog box will be displayed.


                                                                      Electronic Spreadsheet (Advanced) using LibreOffice Calc  225
   222   223   224   225   226   227   228   229   230   231   232