formula {=TABLE(G13;)}

G

Guylaine

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...
 
D

Dave F

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
 
Top