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

