Calc Guide

4) Choose Data > Multiple Operations.
5) With the cursor in the Formulas field of the Multiple operations dialog, select
cells B5 and C5.
6) Set the cursor in the Column input cell field and click cell B4. Figure 247
shows the worksheet and the Multiple operations dialog.
Figure 247: Sheet and dialog showing input
7) Click OK. Now the profits are listed in column E and the annual profit per item
in column F.
Figure 248: Results of multiple operations calculations
252 OpenOffice.org 3.3 Calc Guide