View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan Beban Alan Beban is offline
external usenet poster
 
Posts: 200
Default how do i square matrices?

sparkskey wrote:
hello!!!how do i square matrices??like put matrices to the power of something
on excel???please help!!need it for my math portfolio!!


First off, assuming that by squaring a matrix you mean the result of the
matrix multiplication of a matrix by itself, this only works for square
matrices.

Assuming that the matrix values are in A1:C3,

=MMULT(A1:C3,A1:C3), array entered into a 3x3 range, will give you the
square;

=MMULT(MMULT(A1:C3,A1:C3),A1:C3), array entered into a 3x3 range, will
give you the cube; etc.

Alan Beban