Mystery Formula

[Mike Polo]

The reference below is in an entire column of cells. The cell C7 is a
number (14,000) that appears to be a constant multiplier for the entire
column. I'm trying to find out what the , in front of the cell reference
signifies, and what "TABLE" is being referenced.

Thanks!

{=TABLE(,C7)}

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Kevin H. Stecyk]

Mike Polo wrote...

The reference below is in an entire column of cells. The cell C7 is a
number (14,000) that appears to be a constant multiplier for the entire
column. I'm trying to find out what the , in front of the cell reference
signifies, and what "TABLE" is being referenced.

Thanks!

{=TABLE(,C7)}

Hi Mike,

That is a data table. You should read Excel's help on data tables. They
are very effective for varying one or two variables and showing the results.

Once you read XL's help on data tables, it should be clearer.

If not, please post back.

Regards,
Kevin

 

[Harlan Grove]

Mike Polo wrote... ....
....
That is a data table. You should read Excel's help on data tables.
They are very effective for varying one or two variables and showing
the results.

Once you read XL's help on data tables, it should be clearer.

....

Using data tables may be clear, but the TABLE pseudofunction isn't mentioned
in online help for data tables, and I don't believe you can find it using
the keyword Table.

 

[Kevin H. Stecyk]

Harlan wrote...

...
Using data tables may be clear, but the TABLE pseudofunction isn't
mentioned
in online help for data tables, and I don't believe you can find it using
the keyword Table.

Harlan,

Point well taken. The OP must first get familiar with data tables so that
he can understand what is taking place. And I suspect once he tries an
example or two, he will recognize that {=table(RowInput, ColumnInput)} is
the syntax being used. The table is merely the data table that has been
created. It's important that the OP understands the structure of the data
table as well. Now he will understand where the answer is derived from and
what the input(s) are.

I know you know all this stuff, but I am just adding this text in case the
OP returns to see if more information has been written.

I think most users are quite amazed when they use data tables for the first
time and recognize their power.

Thank you for additional comments.

Regards,
Kevin