Manuals/calci/MDETERM
Syntax
Remarks
Examples
''''''' ''''
Description
MDETERM
MDETERM(a)
Where a is a numeric array, have same number of rows and columns.
- a can be given as a cell range, {1,2,3;4,5,6;7,8,9}; or as a name to either of these.
- Matrix determinants are generally used for solving systems of mathematical equations that involve several variables.
MDETERM function gives you the matrix determinant of an array.
C1 C2 C3 C4
R1 2 3 4 5
R2 2 5 1 4
R3 5 5 4 6
R4 4 1 5 2
That is MDETERM (B2:E5) is 84
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 2 | 3 | 4 | 5 |
| Row2 | 2 | 5 | 1 | 4 |
| Row3 | 5 | 5 | 4 | 6 |
| Row4 | 4 | 1 | 5 | 2 |
| Row5 | 84 | |||
| Row6 |
