Create a Two Variable Data Table

  • By Doug H
  • 20 September, 2017
  • Comments Off on Create a Two Variable Data Table

In a previous post I showed you how to create a one variable data table. You should know by now how Excel just wants you to be able to do more! So much more that there is a two variable data table feature. The use case for this is if you want to input two varying pieces of data and see how the output changes. For example say you are taking out a loan and maybe not sure how much you want to take out. At the same time you are unsure of the rate you might get. What are the possibilities of monthly payments you’ll have? It’s almost endless! With a two variable data table you can a range of interest rate AND a range of loan amounts and let the handy-dandy data table feature figure out the different monthly payments that are possible. Amazing! See the magic at work in the video.


Categories: Excel 2007 and up

Comments are closed.

Read previous post:
Create a One Variable Data Table

Ever heard of a variable table? What about a one variable table? Well if you haven't you've step into the...