MMULT Function in Google Sheets

Multiply two matrices using the MMULT function.

MMULT Function

The MMULT function in Google Sheets performs matrix multiplication on two matrices.

Syntax

MMULT(matrix1, matrix2)
  • matrix1: The first matrix to multiply.
  • matrix2: The second matrix to multiply.

Examples

  1. Basic Example

Multiply matrix A1:B2 with matrix C1:D2:

=MMULT(A1:B2, C1:D2)

Notes

  • The number of columns in the first matrix must equal the number of rows in the second matrix.