formula {=TABLE(G13;)}

[Guest]

I found the formula {=TABLE(G13} in a worksheet, and I would like to know
its function. I've checked in Visual Basic and did not find any macro under
that name...

 

[Guest]

It's an array formula, as indicated by the squiggly brackets { }

Array formulas are entered by pressing CTRL+SHIFT+ENTER at the same time, as
opposed to the conventional way of just hitting ENTER.

Array formulas essentially perform multiple calculations across a range.

I think the TABLE function is used for data tables. See this for more info
about data tables: http://www.ozgrid.com/Excel/data-tables.htm

Dave

 

[Guest]

It's an array formula, as indicated by the squiggly brackets { }

Array formulas are entered by pressing CTRL+SHIFT+ENTER at the same time, as
opposed to the conventional way of just hitting ENTER.

Array formulas essentially perform multiple calculations across a range.

I think the TABLE function is used for data tables. See this for more info
about data tables: http://www.ozgrid.com/Excel/data-tables.htm

Dave

 

[Bob Umlas]

It's put in by Excel (you can't enter it) when you use the Data/Table
command

 

[Bob Umlas]

It's put in by Excel (you can't enter it) when you use the Data/Table
command