Calc Guide

6) Set the cursor in the Column input cell field and click cell B4. This
means that B4, the quantity, is the variable in the formula, which
is to be replaced by the column of alternative values. Figure 228
shows the worksheet and the Multiple operations dialog.
7) Click OK. The profits for the different quantities are now shown
in column E. See Figure 229.
Tip
You may find it easier to mark the required reference in the
sheet if you click the Shrink icon to reduce the Multiple
operations dialog to the size of the input field. The icon then
changes to the Maximize icon; click it to restore the dialog to its
original size.
Figure 228: Sheet and Multiple operations dialog showing input
284 OpenOffice.org 3.x Calc Guide