How can I square a Matrix in Calc like MMULT


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.