You can use Excel data tables to test how your formula results will vary when the data that the formula operates on changes. You do this by specifying a series of hypothetical values that Excel will use to evaluate the formulas with.
This allows you to then view the results of the
evaluations and compare the results for the different data inputs. Data tables save you
the trouble of entering a series of input values into a worksheet and
recording each
recalculation of the worksheet
for each new input that you enter. When you use a data
table, Excel will substitute a range of values into the worksheet formulas for you, and
tabulate the results so they can be viewed easily.
In Excel, you can create a single
input data table or a two input
data table. A single input table will substitute
a range
of values as a single variable in
as many formulas as you like.
With
a two input data table, you can specify
ranges for two input variables, but these input variables
can
only be applied to one formula.
No comments:
Post a Comment