matrix multiplication

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

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
 
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
 
Back
Top