Hello,
I want to square a Matrix (or use an other exponent) in the same way as the MMULT function works. So I don’t want thet Matrix is multiplied by it´s components, instead i want that Calc makes a Row*Column multiplication.
Thank you in advance!
Best Regards,
Dominik Rutschmann
MMULT does a Row*Columns multiplication. If you want to square a matrix it has to have equal numbers of rows and columns otherwise it does not work.
Thank you.
You cannot use the ^n operator on a matrix function. You have to do it “by hand”.
Assuming your matrix is A1:C3 (3x3). Enter in cell D1 the following formula
=MMULT(A1:C3;A1:C3). Then you get the squared matrix in D1:F3. Now in cell G1 enter
=MMULT(D1:F3;A1:C3) which results in the cubic matrix in G1:I3.
That’s how you have to do it.