Page 669 - Excel 2013 All-in-One For Dummies

Figure 1-4 shows the completed two-variable data table with the results of changing both the projected growth rate and the projected expenses. As with a one-variable data table, you can save this two-variable data table as part of your worksheet. You can also update the table by changing any of the (two types) input variables.
The array formula entered in the output range (C8:F17) to create this two- variable data table is very similar to the one created previously for the one- variable data table, only this time the TABLE function uses both a row_ref and column_ref argument as follows:
{=TABLE(B4,B3)}
Remember that because this data table used an array formula, you must select all the cells in the output range if you want to delete them.
Using Data Tables 651
Figure 1-4:
The completed two-variable data table.
Book VII Chapter 1
Performing What-If Scenarios