Named ranges in Excel's MMULT function do not return valid results

[Guest]

Named ranges in Excel's MMULT function are accepted, but do not return valid
results. Anybody know why, or an I doing something wrong?.

 

[Frank Kabel]

Hi
post the exact formula you have used together with:
- the defined name formula
- the error result

 

[Guest]

I cannot say more than Frank Kabel has said. Keep in mind that matrix
multiplication is only defined if the number of columns of the left-hand
matrix is equal to the number of rows of the right-hand matrix.

 

[Harlan Grove]

Named ranges in Excel's MMULT function are accepted, but do not return
valid results. Anybody know why, or an I doing something wrong?.

If A1:C1 contains {1,2,3} and is named X, and E1:E3 contains {4;5;6} and is
named Y, the formula =MMULT(X,Y) returns {32}, the correct answer, and the
formula =MMULT(Y,X) returns {4,8,12;5,10,15;6,12,18}, also the correct
answer. You need to give more details.