MDETERM
Formulas / MDETERMCompute the matrix determinant of an array.
MDETERM(array)
- array - a numeric array with equal rows and columns
Examples
=MDETERM(A2:D5)The function is used to return the determinant of a matrix. For example, the formula returns the determinant of the matrix found in the range A2:D5.
=MDETERM({3,6,1;1,1,0;3,10,2})The function can also be used with an array constant. For example, the formula returns the determinant of the matrix found in the array constant.
=MDETERM(MMULT(A1:C3,D1:F3))The function can be used with certain Sourcetable functions that return a matrix as a result. For example, the MMULT function can be used with the MDETERM function to return the determinant of the result matrix of the MMULT function. The formula returns the determinant of the result matrix of the MMULT function.
Summary
The MDETERM function is a Sourcetable tool used to calculate the matrix determinant of a numeric array. It requires an array argument with an equal number of rows and columns as input.
- The MDETERM function returns the matrix determinant of an input array, which must be of square shape and have equal rows and columns. It takes one argument, a range of values or an array constant.
- The array argument must be a square matrix with the same number of rows and columns.
Frequently Asked Questions
What is the MDETERM Function?
What is returned if the array is empty or contains text?
How accurate is the MDETERM Function?
