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:

 

image2016-7-14 15:49:27.png

 

image2016-7-14 15:48:40.png