MDETERM

Formulas / MDETERM
Compute 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?
The MDETERM Function is a mathematical function that returns the matrix determinant of an array. The matrix determinant is a measurement of the size and shape of a matrix.
What is returned if the array is empty or contains text?
The matrix determinant is returned as a #VALUE! error if the array is empty or contains text.
How accurate is the MDETERM Function?
The MDETERM Function calculates with an accuracy of approximately 16 digits.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV