Page 225 - TP_IT_V1.0_C10_flipbpookl
P. 225

The Goal Seek dialog box opens containing following three options:
                 •  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 6:   Click in the Formulas text box and select the cell in the sheet that contains the formula.  The address of the
                         cell is displayed in the Formulas text box.

                 Step 7:  Click in the Target value text box and type the target value in it (1500).

                 Step 8:   Click in the Variable cell text box and select the cell that contains the value you want to adjust in order to
                         achieve the target value.  The address of the cell is displayed in the Variable cell text box.

                 Step 9:  Click on OK button.

















                         The LibreOffice Calc message box appears that show the message Goal Seek was successful.
                 Step 10:  Click on Yes to change the cell B1 with the new value predicted 250 that will make the profit 1500 for the
                         month.

















                 The spreadsheet with the new changes with the predicted value (number of pastries to sell) to get the desired profit
                 is shown below:





















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