Calc Guide

Figure 229: Sheet showing results of multiple operations calculations
Calculating with several formulas simultaneously
1) In the sheet from the previous example, delete the contents of
column E.
2) Enter the following formula in C5: =B5/B4. You are now
calculating the annual profit per item sold.
3) Select the range D2:F11, thus three columns.
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 230 shows the worksheet and the Multiple operations
dialog.
Chapter 9 Data Analysis 285