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.