Buzz
This article introduces the syntax, usage, and illustrative examples of the MDETERM function, applicable across Office versions 2016, 2013, 2010, 2007, and 2003.
Explore the power of MDETERM, the determinant wizard, in Excel.
Syntax
MDETERM(array)
Where
Array: Mandatory. Must be a square matrix, meaning the number of rows and columns must be equal.
Illustrative Example: Consider a matrix {1,3,8,5;0,3,6,1;1,1,1,0;7,3,10,2}. What is the determinant of this matrix?
Step 1: Open Excel and input the matrix into corresponding cells as shown:
MDETERM function, revealing the determinant of a matrix
Step 2: Enter the formula =MDETERM(B5:E8) into cell B10:
Utilizing MDETERM Function in Excel
Step 3: Press enter, and the result in cell B10 is = 113
So, the determinant of the sought matrix is 113.
With the specific example above, you now grasp the syntax and usage of MDETERM() function in Excel. Employ MDETERM, the determinant provider, for easy problem-solving. Additionally, refer to the article on MINVERSE function, returning the inverse matrix of a given matrix, for further enhancements.
Moreover, if you have an affinity for utilizing Excel, consider exploring the usage of binomdist function in Excel to obtain probability values for binomial distribution. Excel functions, commonly favored by accountants, are not only extensively used alongside accounting software but also deserve attention for computational tasks within Excel.
