Matrix Functions

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

M_DETERM(array)

Returns as a value the determinant of a square matrix.

M_INVERSE

M_INVERSE(array)

Returns the inverse of a square matrix.

M_MULT

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

TRANSPOSE(array)

Converts an m*n array into its n*m transpose.