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

