One-Input
Tables
Take a
look at the following spreadsheet.
 |
This
spreadsheet takes the total budget from the previous year,
assumes an increase of 3.5%, and calculates next year's
budget. |
Of course,
the problem is that we do not know if there will be a 3.5%
increase. For this, we can set up a table in another part
of the spreadsheet with varying increases.
If we
highlight cells D3:E10, we can then choose the Data|Table
menu.
We then
choose the cell in the formula that has the varying number;
B9 in this case. We add that to the Column Input Cell box.
Excel will then substitute each percentage into the formula
for B9. Here is the resulting table.
|
