Array fucntions

  • Thread starter Thread starter Gregory OUSTED
  • Start date Start date
G

Gregory OUSTED

I have seen an array function used {=TABLE(,Cell ref)} which changes the
value of a cell depending on the value of cell ref cell. Does any one know
how it works
 
{=TABLE(,Cell ref)}

Its a "one variable data table" which is used for sensitivity analysis.
Albeit it looks like an array formula, it's not. The table needs to be set up
via the menu command: Data > Table..

You could try typing in Excel's help: one variable data table
for more information

I also have 2 data table samples in my archives:

http://savefile.com/files/1007074
One variable data table example.xls

http://savefile.com/files/46276
2 variable data table example.xls
 
Back
Top