Finding a function in Excel
 

Years ago, when I was working, I remember using a function that
would allow you to build a table of output using one, and hopefully
two, input variables. This is probably best illustrated with an
example.
Suppose you had an array of numbers, say 3 by 3, with three other
cells, two for input values and a third for an output value. In both
input cells you would put numbers. The output cell would be calculated
by adding the value of the first input cell to each of the cells in the
array and then multiplying that value (for each cell), by the value in
the second input cell. The sum of the numbers would then be put into
the output cell.
Now suppose you want to see what happens when you vary the input
values over two ranges, say 1 to 10 for the adder cell, and 5 to 15 for
the multiplier cell. You would want to construct a table with the
values that the input cell takes on as a column and the values of the
multiplier cell as a row at the top of the table. At each
intersection, then, the value of the output cell, for each value of the
adder cell (row) and multiplier cell (column), would be displayed.
I can't seem to find such a function in Excel and was wondering if
anyone knew whether it still existed, or was available some other way.

Regards

John Kirby

It sounds as though you are looking for the Data-Table... functionality.
Look at "Data Tables" in the Help file


"JSK" wrote:

Years ago, when I was working, I remember using a function that
would allow you to build a table of output using one, and hopefully
two, input variables. This is probably best illustrated with an
example.
Suppose you had an array of numbers, say 3 by 3, with three other
cells, two for input values and a third for an output value. In both
input cells you would put numbers. The output cell would be calculated
by adding the value of the first input cell to each of the cells in the
array and then multiplying that value (for each cell), by the value in
the second input cell. The sum of the numbers would then be put into
the output cell.
Now suppose you want to see what happens when you vary the input
values over two ranges, say 1 to 10 for the adder cell, and 5 to 15 for
the multiplier cell. You would want to construct a table with the
values that the input cell takes on as a column and the values of the
multiplier cell as a row at the top of the table. At each
intersection, then, the value of the output cell, for each value of the
adder cell (row) and multiplier cell (column), would be displayed.
I can't seem to find such a function in Excel and was wondering if
anyone knew whether it still existed, or was available some other way.

Regards

John Kirby