Assessing the Impact of Variables Using Data Tables
A data table is a tool you can use to calculate how one or two variables change the result of a calculation. Use a data table when you want to see the range of results in a worksheet rather than seeing a single result at a time.
Creating a Data Table with One Variable
When you need to see how only one variable changes the result of a calculation, you can quickly create a data table. You place the input values—the values you want to test—in either a row or a column, and then tell Excel where to find them.
Creating a data table seems odd at first, but you'll quickly get the hang of it. Try this example of putting together a data table that uses one variable.
First, create a new worksheet and set ...