The MMULT function in Google Sheets is a powerful tool designed for performing matrix multiplication. This function allows users to calculate the product of two matrices, enabling complex data analysis and mathematical computations within spreadsheet applications.

Syntax

MMULT(array1, array2)

• array1: The first matrix or array to multiply.
• array2: The second matrix or array to multiply.

Example #1

=MMULT(A1:B2, C1:D2)

This function multiplies the two matrices defined by ranges A1:B2 and C1:D2, yielding a result of 19 and 22. The result represents the calculated matrix product based on the provided ranges.

Example #2

=MMULT(D1:E2, F1:G2)

Here, the function computes the multiplication of matrices within ranges D1:E2 and F1:G2, resulting in 43 and 50, demonstrating the function’s ability to handle different matrix setups.

Example #3

=MMULT(A1:A3, B1:B3)

This example multiplies matrices taken from range A1:A3 and B1:B3, providing a single value result of 30, illustrating how MMULT can also work with column vectors to produce scalar output.

Error handling

• VALUE!: This error occurs when the matrix dimensions are incompatible for multiplication. Ensure the number of columns in the first array matches the number of rows in the second array.
• REF!: Indicates that one of the specified ranges is invalid, possibly due to a deleted range. Check the ranges provided for correctness.

Conclusion

In summary, the MMULT function is an essential tool for anyone needing to perform matrix multiplication within Google Sheets. By understanding its syntax and how to handle potential errors, users can leverage this function to enhance their data analysis capabilities effectively.