Excel 2010 Evaluating Matrix Determinant (MDETERM Function)

Apart from supporting statistical and financial functions, Excel also contains some advance mathematical  functions. Matrix operations have been widely used for various purposes. Excel MDETERM function allow users to find out the determinant of given matrix. It has made evaluating determinant dead-easy for users working with matrices.

Launch Excel 2010 spreadsheet on which you want to apply Matrix determinant. For instance, we have included a spreadsheet containing fields Matrix and Determinants.

You might have been acquaint with the orthodox way of finding out matrix determinant.

|A| = (a*b)-(c*d)

Where a,b,c, and d are the elements stored in matrix. With Excel built-in function we don’t need to write in lengthy formula to calculate the determinant of matrix. The MDETERM function will allow us to evaluate determinant instantly.

The syntax of this function is;


It requires single argument in the form of array. In our case array is matrix containing integers.

We will be writing this formula as


The argument in the function is A2:B3, which is the location of the cells containing elements of matrix. We will be writing this formula in first row of Determinants field. It yields –2 by evaluating the whole formula, as shown in the screenshot below.

determinant Excel 2010 Evaluating Matrix Determinant (MDETERM Function)

Now we will be applying this formula on the Determinants column, just copy the cell containing formula, and paste it into other cells. The cell location will change automatically on pasting the formula in other cells.


If you want to evaluate determinant by specifying values directly, then you need to write it as;



You can also check out previously reviewed Excel Functions; DOLLAR, SUMPRODUCT, SUMIF, COUNTIF, VLOOKUP, HLOOKUP ,PMT, and LEN.

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

Your email address will not be published. Required fields are marked *