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.
