MDeterm(Values)
Values. Cell range containing a two-dimensional numeric array with equal number of rows and columns.
NOTE. To define the range, specify the addresses of the upper left and the lower right cells where the matrix is located.
It returns the matrix determinant of a cell array.
Determinant of matrix is a number calculated based on the values of array elements.
The MDeterm function returns an error value if:
Any of the array cells is empty or contains text.
The array does not have an equal number of rows and columns.
The source matrix looks as follows:
| Formula | Result | Description |
| =MDeterm(A0:C2) | 8644 | The determinant of the above given matrix. |
See also:
Function Wizard │ Mathematical Functions │ MInverse │ MMult