Newbie: Excel 2000 formula {=TABLE(E26,)} Que?

[Brian Dobby]

Hi. I'm not a regular (let alone expert) Excel user. I have been given
a worksheet which I need to analyse to reproduce the calculations in a
procedural programming language. Several of the cells contain this
formula: {=TABLE(E26,)}

I don't know what this means. I know(?) the braces indicate an array
function. Cell E26 contains an interest rate. But I can find no
function called 'TABLE', nor do I know what data is being combined
with the interest rate to produce the result.

Can anyone explain what's going on? Apologies if it's something really
obvious.
TIA
Brian

 

[Mike Lewis]

Brian,

What you are seeing is the "Data Table" feature. It is
located on the main Excel menu under "Data".

There probably are several cells to the left of these
which contain various intrest rates, and a formula on the
top of these which has a formula that references cell E26.

The way it works is that each of the values to the left
are "placed", one at a time into cell E26, and the results
of the formula are "placed" in the cells that you see with
the {=TABLE(E26,)} formula.

Mike

 

[Brian Dobby]

Mike,
Many Thanks!
Brian

Brian,

What you are seeing is the "Data Table" feature. It is
located on the main Excel menu under "Data".

There probably are several cells to the left of these
which contain various intrest rates, and a formula on the
top of these which has a formula that references cell E26.

The way it works is that each of the values to the left
are "placed", one at a time into cell E26, and the results
of the formula are "placed" in the cells that you see with
the {=TABLE(E26,)} formula.

Mike