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

100

101

Enter each of the values mentioned above into adjacent cells (for Capital, C, an

arbitrary value like $100,000 or it can be left blank; for number of years, n, 1; for

interest rate, i, 7.5%). Enter the formula to calculate the interest, I, in another cell.

Instead of C, n, and i, use the reference to the cell with the corresponding value. In

our example (Figure 249), this would be =B1*B2*B3.

1) Place the cursor in the formula cell (B4), and choose Tools > Goal Seek.

2) In the Goal Seek dialog, the correct cell is already entered in the Formula cell

field.

3) Place the cursor in the Variable cell field. In the sheet, click in the cell that

contains the value to be changed, in this example it is B1.

4) Enter the desired result of the formula in the Target value field. In this

example, the value is 15000. Figure 251 shows the cells and fields.

Figure 251: Example setup for goal seek

5) Click OK. A dialog appears informing you that the Goal Seek was successful.

Click Yes to enter the goal value into the variable cell. The result is shown

below.

Figure 252: Result of goal seek operation

Chapter 9 Data Analysis 255

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

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

Žádné komentáře

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

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

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