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

4) Set the cursor in the Row input cell field and click cell B1. This means that B1,

the selling price, is the horizontally entered variable (with the values 8, 10, 15

and 20).

5) Set the cursor in the Column input cell field and click cell B4. This means that

B4, the quantity, is the vertically entered variable.

6) Click OK. The profits for the different selling prices are now shown in the

range E2:H11.

Figure 250: Results of multiple operations calculations

Working backwards using Goal Seek

Usually, you create a formula to calculate a result based upon existing values. By

contrast, using Tools > Goal Seek you can discover what values will produce the

result that you want.

To take a simple example, imagine that the Chief Financial Officer of a company is

developing sales projections for each quarter of the forthcoming year. She knows

what the company’s total income must be for the year to satisfy stockholders. She

also has a good idea of the company’s income in the first three quarters, because of

the contracts that are already signed. For the fourth quarter, however, no definite

income is available. So how much must the company earn in Q4 to reach its goal? The

CFO can enter the projected earnings for each of the other three quarters along with

a formula that totals all four quarters. Then she runs a goal seek on the empty cell for

Q4 sales, and receives her answer.

Other uses of goal seek may be more complicated, but the method remains the same.

Only one argument can be altered in a single goal seek.

Goal Seek example

To calculate annual interest (I), create a table with the values for the capital (C),

number of years (n), and interest rate (i). The formula is I = C*n*i.

Let us assume that the interest rate i of 7.5% and the number of years n (1) will

remain constant. However, you want to know how much the investment capital C

would have to be modified in order to attain a particular return I. For this example,

calculate how much capital C would be required if you want an annual return of

$15,000.

254 OpenOffice.org 3.3 Calc Guide

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

Sin comentarios

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