I was recently asked a question by my customer to explain what was meant by
the way a function was written. I could not answer as I have not seen a
function/formula written in this manner. I'm hoping someone can give me a
hand.

Here is the formula: {=TABLE(,Q4)}

Not entierly sure, but have never used a TABLE function. Also of note, cell
referece (Q4) is blank in the workbook. For whatever reason, customer states
that the result is correct.

Help anyone?
--
Chris Campana

It could be a Userdefined Function (UDF) and we would have no way of knowing
what it does. It looks as if it is array entered. Assuming it is a valid
function, find the workbook it is in, and see if you can find how it is
defined in the VBA portion of your workbook.
--
** John C **


"Chris C" wrote:

I was recently asked a question by my customer to explain what was meant by
the way a function was written. I could not answer as I have not seen a
function/formula written in this manner. I'm hoping someone can give me a
hand.

Here is the formula: {=TABLE(,Q4)}

Not entierly sure, but have never used a TABLE function. Also of note, cell
referece (Q4) is blank in the workbook. For whatever reason, customer states
that the result is correct.

Help anyone?
--
Chris Campana

This relates to a data table. Here is a link to another thread in the
archives on the same subject:

http://groups.google.com/group/micro...b227013531 a4

A google search reveals many more references which you might care to
look at.

Hope this helps.

Pete

On Nov 5, 5:19*pm, Chris C wrote:
I was recently asked a question by my customer to explain what was meant by
the way a function was written. *I could not answer as I have not seen a
function/formula written in this manner. *I'm hoping someone can give me a
hand.

Here is the formula: *{=TABLE(,Q4)}

Not entierly sure, but have never used a TABLE function. *Also of note, cell
referece (Q4) is blank in the workbook. *For whatever reason, customer states
that the result is correct.

Help anyone?
--
Chris Campana

It's a function for "what if analysis" from the Data menu, DataTable.

I've never used it but Max is the resident expert on this and maybe he'll
see this and chime in.

--
Biff
Microsoft Excel MVP


"John C" <johnc@stateofdenial wrote in message
...
It could be a Userdefined Function (UDF) and we would have no way of
knowing
what it does. It looks as if it is array entered. Assuming it is a valid
function, find the workbook it is in, and see if you can find how it is
defined in the VBA portion of your workbook.
--
** John C **


"Chris C" wrote:

I was recently asked a question by my customer to explain what was meant
by
the way a function was written. I could not answer as I have not seen a
function/formula written in this manner. I'm hoping someone can give me
a
hand.

Here is the formula: {=TABLE(,Q4)}

Not entierly sure, but have never used a TABLE function. Also of note,
cell
referece (Q4) is blank in the workbook. For whatever reason, customer
states
that the result is correct.

Help anyone?
--
Chris Campana

.. {=TABLE(,Q4)}

That's in a one variable data table, which is used to quickly produce
what-if-tables based on 1 variable, in sensitivity analysis. And albeit it
looks very much like an array formula, it cannot be entered as such. It has
to be set-up via the menu command: Data Table.

Try typing in Excel's help: one variable data table
for more information

Try also the 2* samples on data table in my archives:
*one variable, 2 variable

One variable data table example.xls
http://savefile.com/files/1007074

2 variable data table example.xls
http://savefile.com/files/46276
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---