TABLE function?

M

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?
 
S

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

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top