- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Math and Trignometric - MDETERM Function
Description
The MDETERM function returns the matrix determinant of an array.
Syntax
MDETERM (array)
Arguments
Argument | Description | Required/Optional |
---|---|---|
Array | A numeric array with an equal number of rows and columns. | Required |
Notes
Array can be given as a cell range, for example, A1:C3; as an array constant, such as {1,2,3;4,5,6;7,8,9}; or as a name to either of these
The matrix determinant is a number derived from the values in array. For a threerow, three-column array, A1:C3, the determinant is defined as −
MDETERM (A1:C3) =A1*(B2*C3-B3*C2) + A2*(B3*C1-B1*C3) + A3*(B1*C2-B2*C1)
Matrix determinants are generally used for solving systems of mathematical equations that involve several variables
MDETERM is calculated with an accuracy of approximately 16 digits, which may lead to a small numeric error when the calculation is not complete
MDETERM returns the #VALUE! error when
Any of the cells in the array is empty or contains non-numeric values
Array does not have an equal number of rows and columns
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016