Table

  • Thread starter Thread starter Shalin
  • Start date Start date
S

Shalin

I know excel has the feature I simply don't remember what it is
called.

Lets day I have three fields A, B, C.
A and B have a value of some number between 1-10.
C has a formula that simply multiplies A & B.

I would like to create a multiplication table.

There is some feature in excel that allows me to create a table where
if I put the result (C) in the top left corner of the table and then
have different values for x and y then it will automatically fill out
the table based on plugging in the formula.

In this example I have simplified the problem where it would also be
possible to simply put the formula in each cell of the table, however,
in my actual application the result field is a much more complicated
formula that is derived from multiple formulas but I want to vary only
2 cells and I am only interested in the one result.

Thanks.
 
Back
Top