## What is MDETERM Function in Excel?

The **MDETERM **function is one of the math functions of Excel.

It Returns the **matrix determinant of an array**.

We can find this function in **Math & trig** category of insert function Tab.

## How to use MDETERM function in excel

- Click on an
**empty cell**(like F5 )

2. Click on **fx icon** (or press** shift+F3**)

3. In the **insert function tab** you will see all functions

4. Select **math and trig** category

5. Select **MDETERM **function

6. Then select **ok**

7. In the function arguments Tab you will see **MDETERM **function

8. Array is a **numeric array with an equal number of rows and columns**, either a cell range or an array constant

9. You will see **results **in the formula result section

## Examples of **MDETERM** function in Excel

**Example 1:**

**How to use MDETERM function in excel**

You can see examples of MDETERM function below:

**mdeterm**(A2,B3) ----->>>>answer is -2
**mdeterm**(A3,B4) ----->>>>answer is 0
**mdeterm**(A4,B5) ----->>>>answer is 2
**mdeterm**(A5,B6) ----->>>>answer is -4

## What is the purpose of **MDETERM** function?

**MDETERM**

It Returns the **matrix determinant of an array**.

## What is the Return value of **MDETERM** function?

**MDETERM**

It returns a number.

## How many arguments does **MDETERM** function have?

**MDETERM**

This function has just **1** Argument.

The **argument **of MDETERM function is **number**.

Array is a **numeric array with an equal number of rows and columns**, either a cell range or an array constant.

The argument of MDETERM function is **required **and not optional.

```
MDETERM(number) = number
```

## Which version of excel supports **MDETERM** function?

**MDETERM**

This function is available for all excel **versions **(2003-2019)

## Errors in **MDETERM** function

**MDETERM**