ExcelFlux

MMULT function

the matrix product of two arrays.

Math and trigonometry

Where can you use it?

Reporting, manufacturing and engineering teams. When a total, rounding step or numerical transformation is needed, use the example to see which operation fits your inputs.

Scenario in the workbook

Multiply a diagonal matrix by itself. The inner matrix dimensions must agree.

A worked example from the workbook

RowABC
6InputSecond inputPosition
7201
8042
9001
Record 1
=INDEX(MMULT($A$7:$B$8,$A$7:$B$8),C7,C7)

Expected result4

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=INDEX(MMULT($A$7:$B$8,$A$7:$B$8),C7,C7)
Turkish Excel · tr-TR
=İNDİS(DÇARP($A$7:$B$8;$A$7:$B$8);C7;C7)

Worked examples

Multiply a diagonal matrix by itself. The inner matrix dimensions must agree.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B C
6 Input Second input Position
7 2 0 1
8 0 4 2
9 0 0 1
Case Formula Expected result
Record 1 =INDEX(MMULT($A$7:$B$8,$A$7:$B$8),C7,C7) 4
Record 2 =INDEX(MMULT($A$7:$B$8,$A$7:$B$8),C8,C8) 16
Record 3 =INDEX(MMULT($A$7:$B$8,$A$7:$B$8),C9,C9) 4
Microsoft Excel reference