이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
MDETERM(array)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})결과: -2
Calculates the determinant of a 2x2 matrix: (1*4) - (2*3) = -2.
This error occurs if the array is not square or contains non-numeric cells.