Description Computes the determinant of a square matrix.
Syntax MDTERM ( array)
| Argument | Description |
|---|---|
| array | An array of numbers or a range of cells. |
Remarks The determinant can be used as a measurement of the singularity of a matrix. If the matrix represents the coefficients of a set of simultaneous equations, and the determinant is relatively small, this may indicate that one or more pairs of equations (i.e., rows) are closely related and the solution of the simultaneous equations may not be very accurate (if it is computed at all). A value of 0 indicates that the matrix is singular and not solvable (see MINVERSE).
Note In contrast to the closely related functions MINVERSE and MMULT, the result of MDETERM is a single value. MDETERM is not an array function.
Examples The first example uses this worksheet.
This function returns 33:
This function returns 33:
