Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to have a table where in one row there is one variable while on the
left column there is another variable. Inside the table there are the values which depend on the two variables, including a fix value which is outside that table. i am looking at excel spreasheet like that and it seems that if I stand on any of the cells in side the table the function is {=TABLE(cell,cell)} what are the "}" for? I can't find information about a "TABLE" function... Thanks for your help... |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
OS -
The feature is called a Data Table. The function is entered via the Table item on the Data menu (pre-2007 Excel). For more info, search Excel Help for "data tables" or "about data tables." - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "OS" wrote in message ... I want to have a table where in one row there is one variable while on the left column there is another variable. Inside the table there are the values which depend on the two variables, including a fix value which is outside that table. i am looking at excel spreasheet like that and it seems that if I stand on any of the cells in side the table the function is {=TABLE(cell,cell)} what are the "}" for? I can't find information about a "TABLE" function... Thanks for your help... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sensitivity analysis | New Users to Excel | |||
How to build effective IF Statement for recurring value in cells....sensitivity analysis | Excel Discussion (Misc queries) | |||
Sensitivity analysis | Excel Worksheet Functions |