Calc Guide

Figure 232: Sheet and dialog showing input
6) Click OK. The profits for the different selling prices are now
shown in the range E2:H11.
Figure 233: 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
288 OpenOffice.org 3.x Calc Guide