MDETERM Function in Excel – Get the Determinant Value of a matrix

MDETERM Function in Excel calculates the determinant value of a square matrix

Syntax for MDETERM Function in Excel

MDETERM( array )

 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:

MDETERM Function in Excel 1

The determinant of the above 2×2 matrix -A, is :

det(A) = ad – bc

Example:

MDETERM Function in Excel 2

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:

MDETERM Function in Excel 3

The determinant of the above 3×3 matrix -A, is :

det(B) = a(ei – fh) + b(fg – di) + c(dh – eg)

Example

MDETERM Function in Excel 4

for the above matrix in excel, apply the MDETERM Formula as shown below

=MDETERM( A1:C3 )

So the resultant determinant value will be 56.

previous-small MDETERM Function in Excel                                                                                                                next_small MDETERM Function in Excel