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?

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.

--
Cheers,
Shane Devenshire


"Mike C" wrote:

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?

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Mike C" <Mike wrote in message ...
|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?