MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Can someone answer this easy table question?


Posted by Doug on February 14, 2002 11:33 AM

How do i make a table and name it? It asks me for
Row Input cell and Column input cell, what part of
my 2 column table do i define those as?


Posted by Mark W. on February 14, 2002 12:07 PM

A simple example of 1-varible and 2-variable tables...

1-variable:

1. Enter the table inputs, {1;2;3;4;5}, into cells
A2:A6.
2. Enter the formula, =D1*10, into cell B1.
3. Now to create the table... but, first
understand that because the table's inputs are
arranged in a column the table has "column" inputs.
Now on with the show... Select cells A1:B6 and
choose the Data | Table... menu command. Because
the inputs are in a column and because we specified
D1 in the table formula as the work area where
each of the column inputs will be evaluated, enter
D1 into the "Column input cell" field and press
[ OK ]. Voila! We've just create a "times 10"
multiplication table.

2-variable:

1. Enter the table's column inputs, {1;2;3;4;5},
into cells A2:A6.
2. Enter the table's row inputs, {1,2,3},
into cells B1:D1.
2. Enter the formula, =F1*G1, into cell A1.
3. Now to create the table... Select cells A1:D6
and choose the Data | Table... menu command.
Because we specified F1 and G1 in the table
formula as the work area where
each ofinputs will be evaluated, enter F1 into the
"Row input cell" field and F1 into "Column input
cell" field and press [ OK ]. Voila! We've just
created a 2-D multiplication table.

Obviously, in the example above it didn't matter
which work area cell, F1 or G1, that we declared
for the row or column input cell, but for a more
complicated table formula (such as the future
value function, FV) it would make a difference!
Hope this helps.