MDETERM
Definition
Returns the matrix determinant of a square matrix specified as an array or range.
Sample Usage
Syntax
MDETERM(square_matrix)
square_matrix- An array or range with an equal number of rows and columns representing a matrix whose determinant will be calculated.
See Also
TRANSPOSE: Transposes the rows and columns of an array or range of cells.
MMULT: Calculates the matrix product of two matrices specified as arrays or ranges.
MINVERSE: Returns the multiplicative inverse of a square matrix specified as an array or range.
In order to use the MDETERM formula, start with your edited Excellentable:
A
|
B
|
|
|---|---|---|
1
|
||
2
|
||
3
|
||
4
|
||
5
|