# How can I square a Matrix in Calc like MMULT [closed]

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.

Best Regards,

Dominik Rutschmann

edit retag reopen merge delete

### Closed for the following reason question is not relevant or outdated by Alex Kemp close date 2015-11-01 12:56:35.644806

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.

( 2013-04-28 20:33:50 +0100 )edit

Sort by » oldest newest most voted

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.

more

Thank you.

more