Re: TABLE worksheet function

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

Anjan said:
Does anyone know how to use the TABLE function in Excel.
Basically I am trying to do a what-if scenario to see
values of a dependent variable based on changes in the
independent variable, all based on a formula. Any help is
much appreciated. Thanks. Anjan
Click to expand...

I was not aware that Excel has a TABLE worksheet function. What version are
you using? What does Help say if you type in "TABLE"?
 
Paul - You are right. Excel help does not come up with
anything when querying for this function. I am using Excel
2000 currently, but I have seen this function used in some
spreadsheets I've come accross. Its just that the usage
does not clarify the functionality. Thanks.
 
If you look at Data in help there are references to Data>Table and how to
use it
 
If we are really talking of a worksheet function (rather than Data > Table
as Peo Sjoblom has suggested) then it must be a user-defined function, so
you would have to refer to the author for details.
 
If we are really talking of a worksheet function (rather than Data > Table
as Peo Sjoblom has suggested) then it must be a user-defined function, so
you would have to refer to the author for details.
Click to expand...

Peo is correct. TABLE (or any variation involving different case of any of its
letters) can't be used as a UDF name. Try it.

TABLE *appears* to be a function, but it is in fact Excel's mechanism for
implementing Data > Table. Since Excel provides automatic recalculation options
including and excluding tables (and always has), it seems (proof would require
reading Microsoft design specs for Excel, if there are any) that Microsoft used
something that looked like a worksheet function to do this. However, TABLE is
*NOT* a worksheet function in the sense that users may type it into formulas in
any range. *ONLY* the Data > Table menu command (or macro equivalents) can
'enter' it into ranges, and it's *ALL* that can appear in such 'formulas'.
 
Back
Top