MDETERM Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

MDETERM is an Excel Math & Trig function. Returns the matrix determinant of an array.

MDETERM syntax

=MDETERM(array)

MDETERM is used in financial models and engineering-style calculations where precise numeric work is needed.

Open the live Excel-style spreadsheet and try MDETERM yourself. No Excel install or sign-up needed to start.

What does the MDETERM function do in Excel?

Returns the matrix determinant of an array.

What is the syntax of MDETERM in Excel?

The syntax is =MDETERM(array). array: The range or array to evaluate.

Where can I practice MDETERM online for free?

Open the free live spreadsheet on Cellgrids and try MDETERM yourself. No Excel install is needed and you can start without signing up.