{=TABLE(,H16)} more help

[David]

Difficult to find detailed help on above function. I get this function not
valid, even if entered as an array formula. I have done this once before and
I know I need to select a region, but it still remains confusing.

 

[Michael R Middleton]

David -

Difficult to find detailed help on above function. I get this function not
valid, even if entered as an array formula. I have done this once before
and I know I need to select a region, but it still remains confusing. <

It's usually entered using the Data | Table command.

There's considerable Help on the "data table" topic.

- Mike

www.mikemiddleton.com

 

[David]

Thanks Michael. I am actually working out of a book and following directions
written by a Microsoft author and am still having some difficulty. It is
becoming a little clearer, but I must be doing something wrong, because I can
not get my answer to replicate the book and I believe the books calculation
is correct.
Thanks again.

 

[JulieD]

Hi David

if you'ld like to mention the book and page number one of us might have it
on the shelf and can take a look at the exercise, or alternatively, if you
feel like typing out the exercise we can check it out - books have been
known to be wrong

Cheers
JulieD

 

[hgrove]

David wrote...

Thanks Michael. I am actually working out of a book and followin directions
written by a Microsoft author and am still having some difficulty. I is becoming a
little clearer, but I must be doing something wrong, because I can no get my
answer to replicate the book and I believe the books calculation i

correct.

The more you use Microsoft software and the more you read Microsof
produced or publiched documentation, the more you'll come to realiz
just how many errors and incompletions or ambiguities there are i
those publications.

Certainly in Excel 97 and 2000 it's not possible to enter TABLE as
function in cell formulas. It can only be 'entered' using the men
command Data > Table... It's Excel's implementation of 123 Release 2'
data tables, and the big difference is that Excel's implementation i
looped into the recalculation functionality while 123's required manua
refresh.

This enhanced functionality in Excel required something th
recalculation facility could work with, and that happens to be th
TABLE pseudofunction. It looks like a function, but it's not a functio
you can enter yourself into cell formulas, and it's completely useles
anywhere else you can enter formulas (data validation, conditiona
formatting, defined names, etc.).

So you need to use Data > Table... to create a range that uses TABLE
I'd be very surprised if your book didn't state this explicitly, so
suspect you're trying to do this on your own without following th
procedures in your book. If so, won't work