MDETERM Function in Excel calculates the determinant value of a square matrix
Syntax for MDETERM Function in Excel
Array – array of numeric values, that represent a square matrix (i.e. has the same number of rows and columns).
Examples for Excel MDETERM Function
Let’s apply Excel MDETERM Function for 2×2 and 3×3 matrix
MDETERM Function in Excel for 2×2 matrix:
The determinant of the above 2×2 matrix -A, is :
det(A) = ad – bc
Example:
for the above matrix in excel, apply the MDETERM Formula as shown below
=MDETERM( A1:B2 )
So the resultant determinant value will be -4
MDETERM Function in Excel for 3×3 matrix:
The determinant of the above 3×3 matrix -A, is :
det(B) = a(ei – fh) + b(fg – di) + c(dh – eg)
Example
for the above matrix in excel, apply the MDETERM Formula as shown below
=MDETERM( A1:C3 )
So the resultant determinant value will be 56.