OpenOffice.org OpenOffice - 3.3 Základní průvodce stáhnout pdf (Strana 253)

100

101

Multiple operations across rows and columns

You can carry out multiple operations simultaneously for both columns and rows in

so-called cross-tables. The formula must use at least two variables, the alternative

values for which should be arranged so that one set is along a single row and the

other set appears in a single column. These two sets of alternative values will form

column and row headings for the results table produced by the Multiple Operations

procedure.

Select the range defined by both data ranges (thus including all of the blank cells

that are to contain the results) and choose Data > Multiple operations. Enter the

cell reference to the formula in the Formulas field. The Row input cell and the

Column input cell fields are used to enter the reference to the corresponding cells of

the formula.

Caution

Beware of entering the cell reference of a variable into the wrong field.

The Row input cell field should contain not the cell reference of the

variable which changes down the rows of your results table, but that of

the variable whose alternative values have been entered along a single

row.

Calculating with two variables

You now want to vary not just the quantity produced annually, but also the selling

price, and you are interested in the profit in each case.

Expand the table shown in Figure 247. D2 thru D11 already contain the numbers

500, 1000 and so on, up to 5000. In E1 through H1 enter the numbers 8, 10, 15 and

20.

1) Select the range D1:H11.

2) Choose Data > Multiple Operations.

Figure 249: Sheet and dialog showing input

3) With the cursor in the Formulas field of the Multiple operations dialog, click

cell B5 (profit).

Chapter 9 Data Analysis 253

1 2 ... 248 249 250 251 252 253 254 255 256 257 258 ... 433 434

Komentáře k této Příručce

Žádné komentáře

OpenOffice.org OpenOffice - 3.3 Základní průvodce Strana 253

Komentáře k této Příručce

Související produkty a manuály pro Software OpenOffice.org OpenOffice - 3.3