Create a One Variable Data Table

  • By Doug H
  • 6 September, 2017
  • Comments Off on 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 right place. A one variable table gives you the ability to put a variable input in and see how that input affects some outputs. For example let’s say you are taking out a loan and wanted to see what your payments would be at 1%, 1.5% or etc. Instead of erasing and plugging in a different interest each time, you can just create a table that list the interest rates ranging from 1% to say 7% in .5% increments. This can be done with a one variable data table. View the video to see how it’s done.


Categories: Excel 2007 and up

Comments are closed.

Read previous post:
Group (Outline) Data in a Worksheet

When you have a table or record of transactions, some items just repeat don't they? If they do, sometimes it's...