If you need to analyze some data and want to see what happens by changing one of the variables then a one input data table will help you analyze that data. Here Gary Schwartz from http://www.jargonfreehelp.com shows us how.
How to use a two input data table: • Excel: Two Input Data Table
In this example, I have used the payment function (PMT) and here is a link to that tutorial • Excel PMT Function for 2003, 2007 and 2010...
This video, like many on my channel, has been created using Camtasia https://techsmith.z6rjha.net/zaqjq0
For more tutorials see my website http://www.jargonfreehelp.com
I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.