MMULT
Returns the matrix product of two arrays.
Math & TrigonometryMath Basics
What it does
Multiplies two matrices.
Syntax
MMULT(array1, array2)
Arguments
array1(array) — First matrix.array2(array) — Second matrix.
Examples
Matrix Multiplication
Multiply matrices.
FORMULA
=MMULT(A1:B1, D1:E2)
RESULT
[5, 11]
SAMPLE DATA
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 1 | 2 | 1 | 3 | |
| 2 | 2 | 4 |