View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default formula {=TABLE(G13;)}

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
--
Brevity is the soul of wit.


"Guylaine" wrote:

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