Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
{=TABLE... what is this?
I have a spreadsheet which contains the formula {=TABLE(C1,C2)} and the
result has nothing to do with what is in those 2 cells. How can I tell what this is referencing? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
{=TABLE... what is this?
KLAOI -
TABLE is an array function that is entered only by using the Data | Table menu item. It "references" the adjacent row and column and the two function arguments. Search Help for "about data tables." - Mike www.MikeMiddleton.com "KLAOI" wrote in message ... I have a spreadsheet which contains the formula {=TABLE(C1,C2)} and the result has nothing to do with what is in those 2 cells. How can I tell what this is referencing? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
{=TABLE... what is this?
Usually a formula is involed as well. Say for example: You want to
determine a monthly payment with the number of months being a variable. Variable Term Monthly Payment Original Loan Info (590.48) PMT(rate,nper,pv) Amount 20,000.00 42 (511.09) Term 36 30 (701.67) Rate 4% 24 (868.50) 12 (1,703.00) When the entire table is selected Including the formula, select DataTable enter in this case, column input cell based on the term. The table function generates new results based on the variable/ "Mike Middleton" wrote in message ... KLAOI - TABLE is an array function that is entered only by using the Data | Table menu item. It "references" the adjacent row and column and the two function arguments. Search Help for "about data tables." - Mike www.MikeMiddleton.com "KLAOI" wrote in message ... I have a spreadsheet which contains the formula {=TABLE(C1,C2)} and the result has nothing to do with what is in those 2 cells. How can I tell what this is referencing? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
Insert rows in linked table that are added to secondary table | Excel Discussion (Misc queries) | |||
Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) | |||
Multiple MS Access table sources for pivot table | Excel Discussion (Misc queries) | |||
PIVOT TABLE - Summary Table into a Databasae Table. | Excel Worksheet Functions |