February 2013
Beginner to intermediate
576 pages
21h 30m
English
Content preview from Excel® 2013 On Demand
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Looking at Alternatives with Data Tables
Data tables provide a shortcut by calculating all of the values in one operation. A data table is a range of cells that shows the results of substituting different values in one or more formulas. For example, you can compare loan payments for different interest rates. There are two types of data tables: one-input and two-input. With a one-input table, you enter different values for one variable and see the effect on one or more formulas. With a two-input table, you enter values for two variables and see the effect on one formula.
Create a One-Input Data Table
Enter the formula you want to use.
If the ...