MDETERM()

Syntax. MDETERM(array)

Definition. This function returns the determinant of an array.

Argument

  • array (required) A numeric array with an equal number of rows and columns

Background. The calculation of the determinant is based on a numeric array. An array can be given as the following:

  • A cell range (for example, A1:C3)

  • An array constant (for example, {1.2.3;4.5.6;7.8.9})

  • A name for a cell range or an array constant

If the cells in the array are empty or contain text, the MDETERM() function returns the #VALUE! error. If the array does not have an equal number of rows and columns, the MDETERM() function returns the #VALUE! error.

Determinants are generally used for solving systems of equations. If the determinant is zero, the equation has no (definite) ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.