![]() In Microsoft Excel, a data table is one of the What-If Analysis tools that allows you to try out different input values for formulas and see how changes in those values affect the formulas output.ĭata tables are especially useful when a formula depends on several values, and you'd like to experiment with different combinations of inputs and compare the results.Ĭurrently, there exist one variable data table and two variable data table. Excel data tables - 3 things you should know.Data table to evaluate multiple formulas.Instead of testing each variable individually, make a What-if analysis data table and observe all possible outcomes with a quick glance! You have built a complex formula dependent on multiple variables and want to know how changing those inputs changes the results. Learn how to create a one-variable and two-variable table to see the effects of one or two input values on your formula, and how to set up a data table to evaluate multiple formulas at once. The tutorial shows how to use data tables for What-If analysis in Excel.
0 Comments
Leave a Reply. |