The MMULT Function: Returns the matrix product of two matrices.

Finding the product of two matrices, solving linear equations, is always a challenging problem. Excel software has the MMULT function to support accurate and easy matrix multiplication. It is applicable to all Excel versions, including Office 2016, 2013, and Office 2010, especially the latest Office 2016 version.

Now, let's delve into the syntax, usage, and specific examples to understand the MMULT function in Office 2010, 2007, which returns the matrix product of two matrices. The MMULT function is applicable to Office 2016, Office 2013, Office 2010, Office 2007, and Office 2003.

The MMULT Function: Returns the matrix product of two matrices.

Syntax:

MMULT(array1, array2)

Example 1:Find the product of two matrices: matrix A { 2,1; 0,2}, matrix B { 1,3; 7,2}

Step 1: Open an Excel spreadsheet and input the two matrices as shown:

Step 2: Enter the formula: =MMULT(B7:C8,F7:G8) in cell B13.

Step 3: Press Enter in cell B13 to return the value 9.

Step 4: Select the data range B13: C14 in cell B13, then press F2.

Step 5: Press the key combination Ctrl+Shift+Enter to obtain the result as shown:

Example 2: Solve the system of equations: 

2x + 4y + 10z = 40

2x + 3y + z = 11

3x + 12y - 2z = 9

Step 1: Open Excel software and input the coefficients of the corresponding equation as shown:

Step 2: Find the inverse matrix of the matrix corresponding to the coefficients of the left-hand side. Specifically, in this case, find the inverse matrix of { 2,4,10; 2,3,1; 3,12 -6}. Enter the formula MINVERSE(A6:C8) as shown:

Step 3: Find the solution of the equation system by calculating the product of the inverse matrix found with the matrix representing the right-hand side:

The corresponding result is: x=1; y=2; z=3

So the above article has guided you on how to use the MMULT function, which returns the matrix product of two matrices. Additionally, you can refer to the MINVERSE function and MDETERM function as well as various other accounting software available at Mytour.

Explore more matrix functions here:

See more: Matrix functions