Returns the matrix determinant of an array.
구문
MDETERM(array)인수
array필수
A numeric array with an equal number of rows and columns.
The MDETERM function calculates the determinant of a matrix provided as an array. The array must be a square matrix with an equal number of rows and columns, otherwise, it returns the #VALUE! error.
=MDETERM({1,2;3,4})→-2Calculates the determinant of a 2x2 matrix: (1*4) - (2*3) = -2.
Prepare the matrix
Ensure your data is arranged in a square range (e.g., 2x2, 3x3) containing only numeric values.
Enter the formula
Type =MDETERM(range) into a cell, replacing 'range' with your matrix reference.
This error occurs if the array is not square or contains non-numeric cells.