#VARIABLE DATA CREATOR HOW TO#

#VARIABLE DATA CREATOR HOW TO#

Read More: How to Perform What If Analysis in Excel (3 Examples) Therefore, based on the input value, a data table will automatically be generated.To end the procedure, click the OK button.

Choose cell $C$5 for the column input cell and cell $C$7 for the row input cell field.

The Data Table dialog box will appear as a result.

Select the Data Table from there after that.

Therefore, under the Forecast group, select the What-If Analysis drop-down menu.

After that, use the ribbon to navigate to the Data tab.

Pick all of the data in the table at this stage.

Select cell F3 and enter the future value from cell C8 there.

Now that we have a two-variable data table set up, we will use the x-axis to represent the interest rate ( ranging from 5% to 12%) and the y-axis to represent the number of years ( ranging from 12 to 16).

To view the outcome, press the Enter key on your keyboard.

Secondly, put the formula into that selected cell.

Firstly, select the cell where you want to put the PMT function to compute monthly payments.

Let’s see the change of two of the input variables simultaneously. It is a component of the financial functions and determines the loan amount based on fixed repayments and a fixed mortgage rate. We will calculate the monthly payments using the PMT function. In this example, we have a dataset containing loan amount, interest rate, number of payments, and monthly payments. Create Two Variable Data Table for Monthly Payment Using Excel What If Analysis Let’s look at the examples for two-variable data tables.ġ.

Users can evaluate two variables or values concurrently or at once in a data table for computation by using the Excel What-If Analysis data table feature. In other terms, it demonstrates how altering two information values can alter the result of a given calculation.Ģ Ideal Examples of Creating Two Variable Data Table with What If Analysis in Excel A two-variable data table demonstrates how different variations of the quantities of the two sets of variables affect the formula outcome. What Is Two Variable Data Table in Excel?ĭata Table variables are one sort of constant that could function as a dataset or a straightforward worksheet with columns and rows and hold large amounts of data.

Variable data creator