TABLE function?

[Mike C]

I have this model that does what-if scenarios and there is a formula written:
{=TABLE(,A1)}.

Can anyone tell me what function this is performing?

More info: the model has 3 scenarios (let's call them 1, 2,3). When 1 is
selected, the model displays the results for scenario 1, etc. However on a
separate sheet, a summary of each of the scenarios is grouped by using the
above formula.

Any ideas?

 

[ShaneDevenshire]

Hi Mike,

This is an array function created by Excel when the command Data, Table is
used. You should look up Data Tables in the help system for a little more
info. These days we generally use regular formulas, or pivot tables to do
similar analysis. By the way you can't enter or edit the TABLE function.

 

[Niek Otten]

This "function" tells Excel that this cell is part of a Data Table, as created in the Data>Table menu. It also indicates which
cells have to be varied.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have this model that does what-if scenarios and there is a formula written:
| {=TABLE(,A1)}.
|
| Can anyone tell me what function this is performing?
|
| More info: the model has 3 scenarios (let's call them 1, 2,3). When 1 is
| selected, the model displays the results for scenario 1, etc. However on a
| separate sheet, a summary of each of the scenarios is grouped by using the
| above formula.
|
| Any ideas?