David wrote...
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.

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

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

This enhanced functionality in Excel required something the
recalculation facility could work with, and that happens to be the
TABLE pseudofunction. It looks like a function, but it's not a function
you can enter yourself into cell formulas, and it's completely useless
anywhere else you can enter formulas (data validation, conditional
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 I
suspect you're trying to do this on your own without following the
procedures in your book. If so, won't work.


--
hgrove
------------------------------------------------------------------------
hgrove's Profile: http://www.excelforum.com/member.php...o&userid=11432
View this thread: http://www.excelforum.com/showthread...hreadid=316151