MDETERM
Returns the matrix determinant of an array.
Math & TrigonometryMath Basics
What it does
Calculates the determinant of a square matrix.
Syntax
MDETERM(array)
Arguments
array(array) — Square matrix.
Examples
Determinant
Calc det of 2x2 matrix.
FORMULA
=MDETERM(A1:B2)
RESULT
-2
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | A | B |
| 2 | 1 | 2 |
| 3 | 3 | 4 |