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.

### Why is Mmult not working in Excel?

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 do you solve a matrix equation in Excel?

If mathematics users want to solve a matrix equation, they can use the MINVERSE and the MMULT function. The MINIVERSE function returns the matrix inverse of an array, while the MMULT function returns the matrix product of two arrays.

### 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.

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

### How do I use Mmult 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.