Math & Trig
All versions
◉ 13 views
=MMULT()
The MMULT function returns the matrix product or multiplication of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2. The way you enter the formula depends on which version of Office 365 you are using.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=MMULT(array1, array2)
Hover argument names in the table for details.
Output typeArray
Popularity10 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx — Coming soon
▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =MMULT() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
🧠 🧠 Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
array1 |
Array | Required | , array2 Required. The arrays you want to multiply. |
▣ Examples
Example 1
=MMULT(A2:C4, E2:F4)
Example 2
=MMULT(B2:E10, H2:H5)
§ Remarks
- The number of columns in array1 must be the same as the number of rows in array2, and both arrays must contain only numbers.
- Array1 and array2 can be given as cell ranges, array constants, or references.
- MMULT returns the #VALUE! error when: Any cells are empty or contain text. The number of columns in array1 is different from the number of rows in array2.
- The matrix product array a of two arrays b and c is: where i is the row number, and j is the column number.
✦ Tips
- The number of columns in array1 must be the same as the number of rows in array2, and both arrays must contain only numbers.
- Array1 and array2 can be given as cell ranges, array constants, or references.
- The matrix product array a of two arrays b and c is: where i is the row number, and j is the column number.
⚠ Common Errors
#VALUE!
MMULT returns the #VALUE! error when: Any cells are empty or contain text.
Fix: Check the dimensions of the two ranges and fill empty cells with zero
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!