TABLE function?
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?
|