The following is from Excel help file:
MMULT(array1,array2)
MMULT returns the #VALUE! error when:
a.. Any cells are empty or contain text.
b.. The number of columns in array1 is different from the number of rows
in array2.
c.. The size of the resulting array is equal to or greater than a total of
5,461 cells.
Note The formula in the example must be entered as an array formula. After
copying the example to a blank worksheet, select the range A8:B9 starting
with the formula cell. Press F2, and then press CTRL+SHIFT+ENTER. If the
formula is not entered as an array formula, the single result is 2.
===========
Yongjun CHEN
"Carine" <[email protected]> wrote in message
news:[email protected]...
> Is there a limit in Excel in the dimensions of the matrices we can
> multiply?
> I am trying to multiply a 113*2 matrix by a 2*113 matrix and get an error.
>
> Thanks,
> Carine
Bookmarks