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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.