MDETERM Function

Summary

MDETERM returns the determinant of a square matrix. In Excel terms, that means you give it a square block of numbers like a 2x2 or 3x3 range, and it gives you one number back.

That number is mainly useful as a checkpoint. If the determinant is 0, the matrix cannot be inverted, so formulas like MINVERSE will fail. That is why MDETERM is often the first thing to run when you are building a matrix model.

MDETERM is more specialized than everyday worksheet functions because it belongs to linear algebra rather than simple business arithmetic. It is useful when the workbook needs a determinant as part of matrix analysis, invertibility checks, or more advanced mathematical models.

Syntax

=MDETERM(array)

The array must be numeric and square. Microsoft notes that MDETERM returns #VALUE! if the range contains blanks or text, or if the number of rows and columns does not match.

Arguments

• array - Required. A square numeric range, array constant, or named array.

MDETERM vs Other Matrix Functions

These matrix functions work together, but they do different jobs. MDETERM is the quick check. The others do the heavier matrix operations after that.

Using MDETERM

The most common use is simple. Run MDETERM before MINVERSE. If the result is 0, stop there because the matrix does not have an inverse. That saves you from chasing a #NUM! error later.

It also helps when you want to understand the matrix itself a little better. In many practical Excel models, you do not need to calculate the determinant by hand. You just need to know whether it is zero, non-zero, or so close to zero that the matrix is unstable. Microsoft also notes that the function is calculated with about 16 digits of accuracy, so a singular matrix can sometimes show a tiny leftover like 1E-16 instead of a perfect 0.

Example 1 - Find a 2x2 determinant

This is the simplest version. You point to a square 2x2 range and Excel returns one value.

This is a useful starting example because it shows that even though the input is a full matrix, the output is just one number. That helps the learner focus on what the determinant actually is in Excel.

=MDETERM(B2:C3)

Example 2 - Check a 3x3 matrix

The formula does not change when the matrix gets bigger. As long as the range stays square, MDETERM can evaluate it.

This makes the example helpful because it shows the rule is about shape, not size. A larger square matrix still uses the same function pattern.

=MDETERM(B2:D4)

Example 3 - Test invertibility

If the determinant is not 0, the matrix can be inverted. That makes this a practical gate before using MINVERSE.

This is one of the most useful real-world checks in the lesson because it turns the determinant into a simple TRUE or FALSE decision before the next matrix step.

=MDETERM(B2:C3)<>0

Example 4 - Use the determinant in another step

Because the result is a single number, you can scale it, compare it, or plug it into another formula without extra handling.

This helps show that MDETERM is not only a diagnostic tool. Once the determinant is returned, it behaves like any other numeric result in the worksheet.

=MDETERM(B2:C3)*10

Conclusion Recap

MDETERM is mainly a checking function. This lesson showed that even though you give Excel a whole matrix, the result comes back as one number, and that number quickly tells you something important about the matrix.

The most useful takeaway is simple: if the determinant is 0, stop before trying MINVERSE. That makes MDETERM a practical first step in matrix work, especially when you want to avoid errors and understand whether the matrix can move into the next calculation.

• Main job: MDETERM returns the determinant of a square numeric matrix.
• Best use: Check whether a matrix can be inverted before using MINVERSE.
• Important rule: The input must be square and numeric.
• Error to expect: #VALUE! appears when the range is not square or contains blanks or text.
• Precision note: A result that should be zero can sometimes appear as a very small number because of floating-point rounding.