In the following illustration, cell D2 contains the payment formula, =PMT(B3/12,B4,-B5), which refers to the input cell B3. You enter the variable values in one column or row, and the outcomes are displayed in an adjacent column or row. For example, you can use a one-variable data table to see how different interest rates affect a monthly mortgage payment by using the PMT function. Use a one-variable data table if you want to see how different values of one variable in one or more formulas will change the results of those formulas. Learn more in the article, Introduction to What-If Analysis.Д¬reate either one-variable or two-variable data tables, depending on the number of variables and formulas that you need to test.

A scenario can have a maximum of 32 different values, but you can create as many scenarios as you want. Although it is limited to only one or two variables (one for the row input cell and one for the column input cell), a data table can include as many different variable values as you want. If you want to analyze more than two variables, you should instead use scenarios. Because you focus on only one or two variables, results are easy to read and share in tabular form.ДЄ data table cannot accommodate more than two variables. Using data tables makes it easy to examine a range of possibilities at a glance. Unlike scenarios, data tables show you all the outcomes in one table on one worksheet. Like scenarios, data tables help you explore a set of possible outcomes. Goal-seek is distinctly different,В it usesп»ї a single result and calculates possible input values that would produce that result. Scenarios and data tables use sets of input values to calculates possible results. There are three types of what-if analysis tools in Excel: scenarios, data tables, and goal-seek. For more information, see Excel What-If Data Tables: Faster calculation with VBA. It does not store any personal data.Note:В You can perform faster calculations with data tables and Visual Basic for Applications (VBA). The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. The cookie is used to store the user consent for the cookies in the category 'Performance'. This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category 'Other. The cookies is used to store the user consent for the cookies in the category 'Necessary'. The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category 'Functional'.

The cookie is used to store the user consent for the cookies in the category 'Analytics'. These cookies ensure basic functionalities and security features of the website, anonymously.

Necessary cookies are absolutely essential for the website to function properly.

Dbvisualizer move results to the side