Matrix Functions

Using arrays (or ranges of cells) and the matrix functions, you can perform addition, subtraction and multiplication on any size matrices. You can also obtain 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

Syntax:

M_DETERM(array_or_range)

Returns as a value the determinant of a square matrix.

M_INVERSE

Syntax:

M_INVERSE(array_or_range)

Returns the inverse of a square matrix as an array.

M_MULT

Syntax:

M_MULT(array_or_range1, array_or_range2)

Returns the matrix product of array_or_range1 and array_or_range2.

Note that this will be of dimension a × c for matrices of dimension array_or_range1 = a × b and array_or_range2 = b × c.

TRANSPOSE

Syntax:

TRANSPOSE(array_or_range)

Converts an m × n array (or range of cells) into its n × m transpose array.