# Matrix functions in Excel

Today I introduce to you the synthesis of **matrix functions** in **Excel 2013.** The article will guide in detail the syntax and specific examples for each matrix function. Hope to help you a lot.

## 1. Transpose function

- **Meaning:** The function returns the transposition matrix of a given matrix. You notice the function is correct with matrices with the same number of rows and columns.

- **Syntax: Transpose (array [n, n])** .

Where: Array is a 2-dimensional array with a row and column index of n.

- **For example:**

**Step 1:** In the cell you want to display the transposition matrix, enter the command as shown:

**Step 2:** Press **Enter** -> display the command you type *False* . Highlight the data area **F11: G12** -> press **F2** -> **Ctrl** + **Shift** + **Enter** .

** Note:** The original matrix has many rows and columns, then you highlight the corresponding data area with so many rows and columns.

## 2. Mdeterm function

- **Meaning:** The function returns the determinant of matrices.

- **Syntax: ** **Mdeterm (array [n, n])** .

Where: Array is a 2-dimensional array with a row and column index of n.

- **For example:**

**Step 1:** In the cell where you need to calculate the determinant, enter the following command:

**Step 2:** Press **Enter,** the result will be:

## 3. Minverse function

- **Meaning:** Returns the inverse matrix of the given matrix.

- **Syntax: ** **Minverse (array [n, n])** .

Where: Array is a 2-dimensional array with equal number of columns and rows.

- **For example:**

**Step 1:** In the cell you want to display the inverse matrix, enter the following command:

**Step 2:** Press **Enter** , highlight the data area **C11: D12** -> press **F2** -> **Ctrl** + **Shift** + **Enter** . The result is as shown in the picture:

## 4. Mmult function

- **Meaning:** Returns the product of 2 matrices.

- **Syntax: ** **Mmult (aray1, array2)** .

Where: The number of columns of matrix 1 is equal to the number of rows of matrix 2.

- **Example:** Find the product of 2 matrices.

+ **Step 1:** In the box you want to display matrix products, enter the command as shown:

**Step 2:** Press **Enter** , highlight the data range **K6: L8** -> press **F2** -> **Ctrl** + **Shift** + **Enter** . The result is as shown below:

In this step, there is a small note in **Step 2** if you highlight the number of rows and columns incorrectly, as shown in the figure:

* Note:* Here matrix 1 (3 rows, 3 columns) x matrix 2 (3 rows, 2 columns) => product matrix has a row index and a column index equal to matrix 2.

Good luck!

## You should read it

- MINVERSE function - The function returns the inverse matrix of a given matrix in Excel
- Summary of trigonometric functions in Excel
- How to fix the SUM function doesn't add up in Excel
- Answer common questions about dot matrix printers
- Complete financial functions in Excel you should know
- Matrix Ransomware is back under the distribution of RIG Exploit Kit
- MS Excel - Lesson 5: Excel formulas and functions
- Summary of information functions in Excel
- Comparison functions in Excel - How to use comparison functions and examples using comparison functions
- Date time functions in Excel
- 10 EXCEL functions that ACCOUNTERS often use
- The 10 most useful but often forgotten functions in excel

## Maybe you are interested

### Understanding the intricate Dynamics of Oil Trade with the Petro-Market Matrix

### Eisenhower Matrix and To-Do List: Which Time Management Style Is Right For You?

### MINVERSE function - The function returns the inverse matrix of a given matrix in Excel

### The Matrix 4, in turn, announced a production suspension because of Covid-19, Keanu Reeves' Day in 2021 could be canceled.

### How to Use MatLab to Solve Matrix Equations and Perform Statistical Analysis

### How to Create a Matrix, Vector, and Cell Array in MATLAB