The Determinant of a square matrix is a measure of scale.
For the following 2x2 and 3x3 matrices:
The determinant of the 2x2 matrix, A, is :
and the determinant of the 3x3 matrix, B, is:
The Excel Mdeterm function calculates the determinant of a square matrix.
The syntax of the function is:
where the array argument is an array of numeric values, that represent a square matrix (i.e. has the same number of rows as columns).
The examples below show the Excel Mdeterm function, used to calculate the determinant of a 2x2 and a 3x3 matrix.
A  B  

1  5  2 
2  7  1 
The above spreadsheet on the right shows a simple 2x2 matrix. The determinant of this matrix can be calculated using the Excel Mdeterm function as follows:
This gives the result 9.
A  B  C  

1  6  4  2 
2  3  5  3 
3  2  3  4 
The determinant of the simple 3x3 matrix aboveon the right can be calculated using the following Excel Mdeterm function:
This gives the result 40.
For further details and examples of the Excel Mdeterm function, see the Microsoft Office website.
If you get an error from the Excel Mdeterm Function, this is likely to be the #VALUE! error:
#VALUE!    Occurs if either:
