What If Analysis - One way Data table in Excel

We will consider the same example we used in Scenario Manager and Goal Seek.

I have added one more field Total amount which is sum of Simple Interest and Principal

One way table helps us to find out what will be the simple interest and total amount for a range of Principal value or Input values.

Let us consider principal value range between 10000 and 70000.

Now we will use  = operator to add value to cell below Simple Interest and Total Amount. The fields are output i.e simple interest and Total amount in our table should always be calculated by the input, in our case it is Principal.

Now, select the table, go to Data tab > What If analysis > Data table.

Since we have our input in column D, we will add the cell referencing Principal in column input cell

Click on OK button to check the results.