Formula Use

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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/lnotes/XLDataTablesMonochrome2001.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

 

[Guest]

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.

 

[Guest]

This is another good link explaining data tables:
http://www.ozgrid.com/Excel/data-tables.htm

Dave

 

[Dave Peterson]

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>

 

[Guest]

Financial analysts and i-bankers use them all the time....

But they tend not to participate in these newsgroups.

 

[Guest]

Thank you for all your help. I found a tutorial from Duke University that I
will try.