MMULT

Formulas / MMULT
Perform matrix multiplication.
MMULT(array1, array2)
  • array1 - required, first array
  • array2 - required, second array

Examples

  • =MMULT(A1, A2)

    The MMULT function can be used to calculate the matrix product of two matrices. For example, this will return the matrix product of A1 and A2. The matrix product of two matrices is the result of multiplying each element of the first matrix by the corresponding element in the second matrix, and then summing the products together.

  • The MMULT function returns an array with the same number of rows as the first matrix (A1) and the same number of columns as the second matrix (A2). For example, if A1 has three rows and A2 has two columns, then the resulting array will have three rows and two columns.

  • =MMULT(A1, A2)

    The MMULT function can also be used to multiply larger matrices. For example, if A1 is a 3x3 matrix and A2 is a 3x4 matrix, then this will return a 3x4 matrix with the result of the matrix multiplication.

  • =MMULT(A1, A2)

    The MMULT function can also be used to multiply matrices with different sizes. For example, if A1 is a 3x3 matrix and A2 is a 4x2 matrix, then this will return an array with three rows and two columns.

Summary

The MMULT function is a mathematical and trigonometric function in Sourcetable which can be used to multiply two arrays of matrices. The number of rows in Matrix 1 must equal the number of columns in Matrix 2 and the dot product of rows and columns is used to calculate the result.

  • The MMULT function returns an array with the same number of rows and columns as the two arrays that have been multiplied together.
  • The MMULT function is found in complex formulas that process multiple rows or columns, and it spills multiple values across the worksheet.


Frequently Asked Questions

What is the MMULT function?
The MMULT function is a spreadsheet formula that multiplies two arrays. It returns an array with the same number of rows and columns as the two arrays that you multiply.
What can I use the MMULT function with?
The MMULT function can be used with cells, array constants, or references.
What should I keep in mind when using the MMULT function?
  • The number of columns in array1 must be the same as the number of rows in array2.
  • The MMULT function returns an array with the same number of rows and columns as arrays1 and 2.
Sourcetable Logo

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code.

Drop CSV