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.

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.

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.

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.

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.

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.

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

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

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.