Matrix Multiplication:Excel SOMETIMES

I am having a problem with matrix functions in general. No matter what
variation of sequences I use (the correct one included) I find that Excel
SOMETIMES only returns a portion of the result, one cell, the a11 location.
It is clear that Excel is doing the calculation properly as it is displayed
in the fx window, when the result is an Identity matrix Excel returns a 1 in
a11 location. I know that I have used the same sequence and procedure and
received different results.
I know I must be doing something wrong but cannot figure it out... help
please.
Bill

Hi Bill,

You don't mention it, so I'll ask: are you beginning by selecting the full
range of cells that the result of your matrix operation should return? For
example, if the operation should return a 4 X 6 matrix, you need to begin by
selecting a 4 X 6 range of cells, and _then_ array-enter the function.

--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


"Matrix Bill" <Matrix [email protected]> wrote in message
news:[email protected]...
> I am having a problem with matrix functions in general. No matter what
> variation of sequences I use (the correct one included) I find that Excel
> SOMETIMES only returns a portion of the result, one cell, the a11
location.
> It is clear that Excel is doing the calculation properly as it is
displayed
> in the fx window, when the result is an Identity matrix Excel returns a 1
in
> a11 location. I know that I have used the same sequence and procedure and
> received different results.
> I know I must be doing something wrong but cannot figure it out... help
> please.
> Bill