Now that you’re familiar with Data Tables, Excel Video 342 shows how to vary two variables instead of just one. As we discussed in Excel Video 341, the biggest trick is to make sure that you get the formula in the right cell, but once you do, it’s easy to create a Data Table that varies both the interest rate and the term of our equipment loan.
What if you want to vary three variables in a two dimensional Data Table? Stay tuned. I’ll give you some ideas in the next Excel Video. Thanks for watching.
