hi there

my formula is

=SQRT(MMULT(MMULT(AV47:BM47,$I$47:$Z$64),TRANSPOSE (AV47:BM47)))

all cells have numbers in them as values.....
i m getting #value ....
can some one pls help ?

sam

Did you array enter the formula? Ctrl+Shift+Enter Rather than just Enter?

--
Regards,
Tom Ogilvy

"Sam" wrote in message
om...
hi there

my formula is

=SQRT(MMULT(MMULT(AV47:BM47,$I$47:$Z$64),TRANSPOSE (AV47:BM47)))

all cells have numbers in them as values.....
i m getting #value ....
can some one pls help ?

sam

Hi

highlight the range you want the matrix to be in so if my matrix is 3x3
then I would highlight the matrix A1:C3. Then enter the matrix formula
and then hold down CRTL-Shift and press enter. This should fill in the
whole matrix with the formula you entered.

Hope this works... its been a while since I used MMULT().

Tom



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

The result for the ranges shown should be a single cell. But as you state,
it still needs to be array entered.
1 x 18 against 18 x 18 gives 1 x 18 against (transpose 1 x 18)
gives a 1 x 1
--
Regards,
Tom Ogilvy


"tomhaddock" wrote in message
...
Hi

highlight the range you want the matrix to be in so if my matrix is 3x3
then I would highlight the matrix A1:C3. Then enter the matrix formula
and then hold down CRTL-Shift and press enter. This should fill in the
whole matrix with the formula you entered.

Hope this works... its been a while since I used MMULT().

Tom



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/