Functions in **Microsoft Excel** help users to calculate complex numbers, look up data, and much more. In this tutorial, we will discuss two **Math and Trigonometry functions** namely: **MINIVERSE** and **MMULT** functions. The MINIVERSE function returns the matrix inverse of an array, while the MMULT function returns the matrix product of two arrays.

The **formula** for the MINIVERSE function is `MINVERSE(array)`

, and the formula for the MMULT is `MMULT(array 1, array 2)`

.

The **syntax** for both formulas is below:

**MINIVERSE***array*: a numeric array with an equal number of rows and columns. It is required.

**MMULT***array 1, array 2*: The arrays you want to multiply. It is required.

Follow the steps below on how to use the MINIVERSE and MMULT function in Excel:

## How to use the MINIVERSE Function in Excel

- Launch
**Microsoft Excel**. - Enter your data or use existing data.
- Highlight the cells where you want to place the result.
- Then on the formula bar, type the ranges
**=MINVERSE(A3:B4)** - Press Enter.

You will notice that the results will give you a numeric array with an equal number of rows and columns.

There are two other methods to use the MINVERSE function.

**Method one** is to click the *fx* button on the top left of the Excel worksheet.

An **Insert Function** dialog box will appear.

Inside the dialog box, in the section **Select a Category**, select *Math and Trigonometry *from the list box.

In the section **Select a Function**, choose the *MINVERSE *function from the list.

Then click *OK.*

*A ***Function Arguments*** *dialog box will open*. *

* *

Type into the entry box the range of cells that contains the array you want to calculate.

Then click *OK*.

**Method two** is to click the **Formulas** tab and click the *Math and Trigonometry *button in the *Function Library* group.

Then select *MINIVERSE* from the drop-down menu.

A Function Arguments dialog box will open.

Follow the same method in Method 1.

Then click *OK*.

## How to use the MMULT function in Excel

- Launch
**Microsoft Excel**. - Enter your data or use existing data.
- Highlight the cells where you want to place the result.
- Then on the formula bar, type the ranges
**=MMULT(A2:C3, F2:G4)** - Press Enter.

You will see the results.

There are two other methods to use the MINVERSE function.

**Method one** is to click the *fx* button on the top left of the Excel worksheet.

An **Insert Function** dialog box will appear.

Inside the dialog box, in the section **Select a Category**, select *Math and Trigonometry *from the list box.

In the section **Select a Function**, choose the *MMULT *function from the list.

Then click *OK.*

A* ***Function Arguments*** *dialog box will open*. *

Type into the entry box the range of cells that contains the array you want to multiply.

Then click OK.

**Method two** is to click the **Formulas **tab and click the *Math and Trigonometry *button in the *Function Library* group.

Then select *MMULT* from the drop-down menu.

A **Function Arguments** dialog box will open.

Follow the same method in **Method 1**.

Then click *OK*.

We hope you understand how to use the MINVERSE and MMULT functions in Microsoft Excel.

However, if the MMULT function in Microsoft Excel returns the error #Value when any cells are empty or contain text or when the number of columns in array 1 is different from the number of rows in array 2.

### How is Mmult calculated?

In Microsoft Excel, MMULT is a Math and Trigonometry function that includes two arguments, array 1 and array 2. When calculating the row count of array 1 must equal the row count of array 2. No matter whether you try this function in Excel or Excel Online, this is how it works.

**READ**: How to use the SERIESSUM function in Excel

### How do you use the Mmult function in Excel?

MMULT is a function in Microsoft Excel that returns the matrix product of two arrays. The MMULT function is not a complicated function if you know how to use it. In this tutorial, we have explained how to use the MMULT function in Microsoft Excel.