Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Use
I have a spreadsheet that I am using for a financial class that I am taking.
The formula is: {=TABLE(,D23)} Can anybody explain this formula please? Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Use
The brackets indicate this is an array formula. An array formula applies the
formula to all of the cells in a range (or array). See this site for more info: http://www.cpearson.com/excel/array.htm The TABLE reference could either be a defined function or a named range. Hit F5 and see if the word TABLE shows up in the list. If it does, select it and you'll have the whole range for TABLE highlighted. If it's a defined function (which is my guess), right click the tab name and "View Code" to see what the TABLE function does in your particular worksheet. -- Please remember to indicate when the post is answered so others can benefit from it later. "Walter H" wrote: I have a spreadsheet that I am using for a financial class that I am taking. The formula is: {=TABLE(,D23)} Can anybody explain this formula please? Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Use
Thank you for the explanation, however, I still fail to understand the
formula. I will read the explanation at cpearson. I tried your suggestion of hittinh F5, but nothing show up. Any other ideas? Thank you. "KC Rippstein" wrote: The brackets indicate this is an array formula. An array formula applies the formula to all of the cells in a range (or array). See this site for more info: http://www.cpearson.com/excel/array.htm The TABLE reference could either be a defined function or a named range. Hit F5 and see if the word TABLE shows up in the list. If it does, select it and you'll have the whole range for TABLE highlighted. If it's a defined function (which is my guess), right click the tab name and "View Code" to see what the TABLE function does in your particular worksheet. -- Please remember to indicate when the post is answered so others can benefit from it later. "Walter H" wrote: I have a spreadsheet that I am using for a financial class that I am taking. The formula is: {=TABLE(,D23)} Can anybody explain this formula please? Thank you. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Use
TABLE is used with data tables. They are used in sensitivity analysis; for
example, analyzing the effect of interest rates on a company's debt. See here for some info: http://www.ce.cmu.edu/~hsm/bca2005/l...chrome2001.pdf Note that the formula you give below is an array formula as the other responder indicated, however, it has nothing to do with named ranges. Dave -- Brevity is the soul of wit. "Walter H" wrote: Thank you for the explanation, however, I still fail to understand the formula. I will read the explanation at cpearson. I tried your suggestion of hittinh F5, but nothing show up. Any other ideas? Thank you. "KC Rippstein" wrote: The brackets indicate this is an array formula. An array formula applies the formula to all of the cells in a range (or array). See this site for more info: http://www.cpearson.com/excel/array.htm The TABLE reference could either be a defined function or a named range. Hit F5 and see if the word TABLE shows up in the list. If it does, select it and you'll have the whole range for TABLE highlighted. If it's a defined function (which is my guess), right click the tab name and "View Code" to see what the TABLE function does in your particular worksheet. -- Please remember to indicate when the post is answered so others can benefit from it later. "Walter H" wrote: I have a spreadsheet that I am using for a financial class that I am taking. The formula is: {=TABLE(,D23)} Can anybody explain this formula please? Thank you. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Use
Did you try right-clicking the worksheet's tab name and viewing the code? A
user defined function should actually be in one of the different "modules" on the left hand side, so click on each one until you see if you can find a code that mentions TABLE. Hopefully it's commented well. -- Please remember to indicate when the post is answered so others can benefit from it later. "Walter H" wrote: Thank you for the explanation, however, I still fail to understand the formula. I will read the explanation at cpearson. I tried your suggestion of hittinh F5, but nothing show up. Any other ideas? Thank you. "KC Rippstein" wrote: The brackets indicate this is an array formula. An array formula applies the formula to all of the cells in a range (or array). See this site for more info: http://www.cpearson.com/excel/array.htm The TABLE reference could either be a defined function or a named range. Hit F5 and see if the word TABLE shows up in the list. If it does, select it and you'll have the whole range for TABLE highlighted. If it's a defined function (which is my guess), right click the tab name and "View Code" to see what the TABLE function does in your particular worksheet. -- Please remember to indicate when the post is answered so others can benefit from it later. "Walter H" wrote: I have a spreadsheet that I am using for a financial class that I am taking. The formula is: {=TABLE(,D23)} Can anybody explain this formula please? Thank you. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Use
This is another good link explaining data tables:
http://www.ozgrid.com/Excel/data-tables.htm Dave -- Brevity is the soul of wit. "Walter H" wrote: Thank you for the explanation, however, I still fail to understand the formula. I will read the explanation at cpearson. I tried your suggestion of hittinh F5, but nothing show up. Any other ideas? Thank you. "KC Rippstein" wrote: The brackets indicate this is an array formula. An array formula applies the formula to all of the cells in a range (or array). See this site for more info: http://www.cpearson.com/excel/array.htm The TABLE reference could either be a defined function or a named range. Hit F5 and see if the word TABLE shows up in the list. If it does, select it and you'll have the whole range for TABLE highlighted. If it's a defined function (which is my guess), right click the tab name and "View Code" to see what the TABLE function does in your particular worksheet. -- Please remember to indicate when the post is answered so others can benefit from it later. "Walter H" wrote: I have a spreadsheet that I am using for a financial class that I am taking. The formula is: {=TABLE(,D23)} Can anybody explain this formula please? Thank you. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Use
I don't remember ever using these things, but look at Data|Table in the
worksheet menubar. From what I see in the newsgroups, not many people use them--or the people who use them don't have many questions! "KC Rippstein hotmail com Did you try right-clicking the worksheet's tab name and viewing the code? A user defined function should actually be in one of the different "modules" on the left hand side, so click on each one until you see if you can find a code that mentions TABLE. Hopefully it's commented well. -- Please remember to indicate when the post is answered so others can benefit from it later. "Walter H" wrote: Thank you for the explanation, however, I still fail to understand the formula. I will read the explanation at cpearson. I tried your suggestion of hittinh F5, but nothing show up. Any other ideas? Thank you. "KC Rippstein" wrote: The brackets indicate this is an array formula. An array formula applies the formula to all of the cells in a range (or array). See this site for more info: http://www.cpearson.com/excel/array.htm The TABLE reference could either be a defined function or a named range. Hit F5 and see if the word TABLE shows up in the list. If it does, select it and you'll have the whole range for TABLE highlighted. If it's a defined function (which is my guess), right click the tab name and "View Code" to see what the TABLE function does in your particular worksheet. -- Please remember to indicate when the post is answered so others can benefit from it later. "Walter H" wrote: I have a spreadsheet that I am using for a financial class that I am taking. The formula is: {=TABLE(,D23)} Can anybody explain this formula please? Thank you. -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Use
Financial analysts and i-bankers use them all the time....
But they tend not to participate in these newsgroups. -- Brevity is the soul of wit. "Dave Peterson" wrote: I don't remember ever using these things, but look at Data|Table in the worksheet menubar. From what I see in the newsgroups, not many people use them--or the people who use them don't have many questions! "KC Rippstein hotmail com Did you try right-clicking the worksheet's tab name and viewing the code? A user defined function should actually be in one of the different "modules" on the left hand side, so click on each one until you see if you can find a code that mentions TABLE. Hopefully it's commented well. -- Please remember to indicate when the post is answered so others can benefit from it later. "Walter H" wrote: Thank you for the explanation, however, I still fail to understand the formula. I will read the explanation at cpearson. I tried your suggestion of hittinh F5, but nothing show up. Any other ideas? Thank you. "KC Rippstein" wrote: The brackets indicate this is an array formula. An array formula applies the formula to all of the cells in a range (or array). See this site for more info: http://www.cpearson.com/excel/array.htm The TABLE reference could either be a defined function or a named range. Hit F5 and see if the word TABLE shows up in the list. If it does, select it and you'll have the whole range for TABLE highlighted. If it's a defined function (which is my guess), right click the tab name and "View Code" to see what the TABLE function does in your particular worksheet. -- Please remember to indicate when the post is answered so others can benefit from it later. "Walter H" wrote: I have a spreadsheet that I am using for a financial class that I am taking. The formula is: {=TABLE(,D23)} Can anybody explain this formula please? Thank you. -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Use
Thank you for all your help. I found a tutorial from Duke University that I
will try. "Dave F" wrote: This is another good link explaining data tables: http://www.ozgrid.com/Excel/data-tables.htm Dave -- Brevity is the soul of wit. "Walter H" wrote: Thank you for the explanation, however, I still fail to understand the formula. I will read the explanation at cpearson. I tried your suggestion of hittinh F5, but nothing show up. Any other ideas? Thank you. "KC Rippstein" wrote: The brackets indicate this is an array formula. An array formula applies the formula to all of the cells in a range (or array). See this site for more info: http://www.cpearson.com/excel/array.htm The TABLE reference could either be a defined function or a named range. Hit F5 and see if the word TABLE shows up in the list. If it does, select it and you'll have the whole range for TABLE highlighted. If it's a defined function (which is my guess), right click the tab name and "View Code" to see what the TABLE function does in your particular worksheet. -- Please remember to indicate when the post is answered so others can benefit from it later. "Walter H" wrote: I have a spreadsheet that I am using for a financial class that I am taking. The formula is: {=TABLE(,D23)} Can anybody explain this formula please? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |