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(array_or_range)
Returns as a value the determinant of a square matrix.
M_INVERSE(array_or_range)
Returns the inverse of a square matrix as an array.
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(array_or_range)
Converts an m × n array (or range of cells) into its n × m transpose array.