MDETERM function
The MDETERM function is one of the math and trigonometry functions. It is used to return the matrix determinant of an array.
Syntax
MDETERM(array)
The MDETERM function has the following argument:
| Argument | Description |
|---|---|
| array | An array of numbers. |
Notes
If any of the cells in the array contain empty or non-numeric values, the function will return the #N/A error.
If the number of rows in the array is not the same as the number of columns, the function will return the #VALUE! error.
How to apply the MDETERM function.
Examples
The figure below displays the result returned by the MDETERM function.
