How to Use Excel MDETERM Function in Office 365? – {with Examples}
Tags: excelfunctions, excelmdetermfunction
Published: 2020-08-25 03:40:53

---
title: How to Use Excel MDETERM Function in Office 365? – {with Examples}
published: true
date: 2020-08-24 12:04:01 UTC
tags: ExcelFunctions,ExcelMDETERMFunction
canonical_url: https://geekexcel.com/how-to-use-excel-mdeterm-function-in-office-365-with-examples/
---

## MDETERM Function in Excel:

In this tutorial, we will guide you to know how to use **Excel MDETERM Function in Office 365** with its syntax, definition, and examples. Let’s see them below!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)



## MDETERM Function – Definition:

- This function **returns the matrix determinant of a given array**.
- The given matrix must be a **square matrix** which means a number of rows and columns are equal.

## Syntax:

**=MDETERM(array)**

### Argument Description:

**Array** – The input array with equal number of rows and columns. You can give the array arguments in two ways, one is selecting a range of input values and another way is providing an array constant like **MDETERM({2,8; 5,7})**.

### Note:

- If the input array doesn’t have an equal number of rows and columns, it returns the **#VALUE!** Error.
- If any cells in the array are empty or contain the string values, this function returns the **#VALUE!** Error.
- A determinant is a number that is derived from the values in an array. For example, for two rows, two columns array the determinant is calculated as,
- **MDETERM(A1:B2) = ((B2\*A1)-(A2\*B1))**.

## Examples:

Let’s see some examples below.

### Example 1:

- Refer to the below example image.
- Here we have given inputs by selecting a range of cells.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-62.png)<figcaption id="caption-attachment-12331">Example 1</figcaption>

### Example 2:

- In this screenshot, we have shown you how to give inputs using the array constant like **MDETERM({2,3;5,7})**.
- Refer to the below image.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/3-39.png)<figcaption id="caption-attachment-12332">Example 2</figcaption>

### Example 3:

- If the input array doesn’t have an equal number of rows and columns, it returns the **#VALUE!** Error.
- If any cells in the array are empty or contain the string values, this function returns the **#VALUE!** Error.

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-47.png)<figcaption id="caption-attachment-12333">Example 3</figcaption>

## Closure:

In this tutorial, we guided you to learn the usage of **Excel MDETERM Function in Office 365** with its syntax, definition, and examples. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Read Also:

- [How to Use Excel EXP Function in Office 365? – [With Examples]](https://geekexcel.com/how-to-use-excel-exp-function-in-office-365-with-examples/)
- [How to Use Excel “FACT Function” in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-fact-function-in-office-365-with-examples/)