OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 250)

Note

Before you choose the Data > Multiple Operations option, be sure to

select not only your list of alternative values but also the adjacent cells

into which the results should be placed.

In the Formulas field of the Multiple Operations dialog, enter the cell reference to the

formula that you wish to use.

The arrangement of your alternative values dictates how you should complete the

rest of the dialog. If you have listed them in a single column, you should complete the

field for Column input cell. If they are along a single row, complete the Row input cell

field. You may also use both in more advanced cases. Both single and double-variable

versions are explained below.

The above can be explained best by examples. Cell references correspond to those in

the following figures.

Let’s say you produce toys that you sell for $10 each (cell B1). Each toy costs $2 to

make (cell B2), in addition to which you have fixed costs of $10,000 per year (cell

B3). How much profit will you make in a year if you sell a particular number of toys?

Calculating with one formula and one variable

1) To calculate the profit, first enter any number as the quantity (items sold); in

this example, 2000 (cell B4). The profit is found from the formula

Profit=Quantity * (Selling price – Direct costs) – Fixed costs. Enter this formula

in B5: =B4*(B1-B2)-B3.

2) In column D enter a variety of alternative annual sales figures, one below the

other; for example, 500 to 5000, in steps of 500.

3) Select the range D2:E11, and thus the values in column D and the empty cells

(which will receive the results of the calculations) alongside in column E.

4) Choose Data > Multiple Operations.

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

cell B5.

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 245 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 246.

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.

250 OpenOffice.org 3.3 Calc Guide

1 2 ... 245 246 247 248 249 250 251 252 253 254 255 ... 433 434

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 250