MDETERM function

Category: Math and trigonometry
Introduced: Excel 2003

Summary

Returns the matrix determinant of an array

Syntax

MDETERM(array) The MDETERM function syntax has the following arguments:
• Array Required. A numeric array with an equal number of rows and columns.

Example

=MDETERM(A2:D5)
=MDETERM({3,6,1;1,1,0;3,10,2})
=MDETERM({3,6;1,1})
=MDETERM({1,3,8,5;1,3,6,1})

Microsoft Support Page

https://support.microsoft.com/en-us/office/mdeterm-function-e7bfa857-3834-422b-b871-0ffd03717020

Back to Functions