Calc Guide

4) Choose Tools > Solver. The Solver dialog opens.
Figure 237: The Solver dialog
5) Click in the Target cell field. In the sheet, click in the cell that
contains the target value. In this example it is cell B4 containing
total interest value.
6) Select Value of and enter 1000 in the field next to it. In this
example, the target cell value is 1000 because your target is a
total interest earned of $1000. Select Maximum or Minimum if
the target cell value needs to be one of those extremes.
7) Click in the By changing cells field and click on cell C2 in the
sheet. In this example, you need to find the amount invested in
Fund X (cell C2).
8) Enter limiting conditions for the variables by selecting the Cell
reference, Operator and Value fields. In this example, the amount
invested in Fund X (cell C2) should not be greater than the total
amount available (cell C4) and should not be less than 0.
9) Click OK. A dialog appears informing you that the Solving
successfully finished. Click Keep Result to enter the result in the
cell with the variable value. The result is shown in Figure 238.
292 OpenOffice.org 3.x Calc Guide