Microsoft Office Tutorials and References
In Depth Information
Playing What-If with Data Tables
Figure 8-3:
Sales
projection
spreadsheet with
a series of
possible
growth and
expense
percentages
to plug in
to a
twovariable
data table.
With these few steps, I created the two-variable data table you see in
Figure 8-4:
1. Select the cell range B7:F17.
This cell range incorporates the copy of the original formula along with
the row of possible expenses and growth-rate percentages.
Figure 8-4:
Sales
projection
spreadsheet
after
creating the
two-variable
data table
in the range
C8:F17.
Search JabSto ::




Custom Search