Carine wrote...
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.

So something like MMULT(A1:B113,TRANSPOSE(A1:B113))? The resulting
array would have dimensions 113*113, so 12,769 entries. That's well
beyond the largest result Excel can return. On the other hand, if you
mean something like MMULT(TRANSPOSE(A1:B113),A1:B113), the resulting
array would only be 2*2, and the only ways Excel would return #VALUE!
would be that some entries in either argument to MMULT weren't numbers
*OR* some of the intermediate calculations caused underflow or overflow
(very rare).

If you mean the former, your only real choices are downloading and
installing Laurent Longre's MOREFUNC.XLL add-in from

http://xcell05.free.fr/english/

and using its MMULT.EXT function, or use a different program to do your
matrix multiplication, e.g., R, APL, Mathematica, Maple, MatLab,
Octave, SciLab, or other math or stats programs.