MDETERM

Definition: MDETERM is a function that returns the matrix determinant of a given array.

Syntax: =MDETERM(array)

Situation: This formula is appropriate when you need to find the matrix determinant of a given array.

Example: If you have a matrix array { {1, 2}, {3, 4} }, the determinant can be found using the formula =MDETERM({{1, 2}, {3, 4}}), which returns -2.