How to Create One and Two Variable Data Tables in Excel
One Variable and Two Variable Data Table in Excel Instead of creating different scenarios, you can create a data table to quickly try out different values for formulas. You can create a one variable data table or a two variable data table. Assume you own a book store and have 100 books in storage. You sell a certain % …