Using arrays, ranges and the matrix functions, you can perform addition, subtraction and multiplication on any size matrices. You can also find the transpose of a matrix and the determinant and inverse of square matrices.
Matrix addition and subtraction is exactly the same as array addition and
subtraction; if you have a 2*3 array in cells A1 to C2 and another in cells A4
to C5, you can add them in A7 by entering {A1C2}+{A4C5}
. This will
result in another 2*3 array in A7 with the result.
M_DETERM(array)
Returns as a value the determinant of a square matrix.
M_INVERSE(array)
Returns the inverse of a square matrix.
M_MULT(array1, array2)
Returns the matrix product of array1 and array2.
Note that this will be of dimension a*c for matrices of dimension array1=a*b and array2=b*c.
TRANSPOSE(array)
Converts an m*n array into its n*m transpose.