Exceljet

Quick, clean, and to the point

Excel MDETERM Function

Excel MDETERM function
Summary 

The Excel MDETERM function returns the matrix determinant of a given array. The input array must contain numbers only and be a square matrix, with equal rows and columns. The result is a number representing the matrix determinant.

Purpose 
Get matrix determinant of given array
Return value 
A number representing the matrix determinant
Syntax 
=MDETERM (array)
Arguments 
  • array - A square array of numbers only.
Usage notes 

The MDETERM function returns the matrix determinant of a given array, which must be a square matrix containing numbers only, and no blanks. In mathematics, a determinant using values in a matrix following a specific definition. The result of MDETERM a number representing the matrix determinant. The array argument can be provided as a range or an array constant.

In the example shown, the formula entered across in M7:

=MDETERM(I7:K9)

Which returns a result of 1.

Notes

  1. The input array must be a square matrix with an equal number of rows and columns
  2. The array argument can be provided as a range or array constant like {4,3;3,2}
  3. Empty cells or text in array will cause MDETERM to return a #VALUE! error
  4. MDETERM returns a #VALUE! if array does not have an equal number of rows and columns

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.