WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » MMULT in Excel

MMULT in Excel

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

What does MMULT Do in Excel?

MMULT is a Math & Trigonometry function in excel, stands for “Matric Multiplication” and returns the product of two arrays of two matrices where the number of rows of Matrix 1 is equal to the number of columns of Matrix 2.

This function applies the logic of multiplying one matrix by another matrix by using the “Dot Product” of rows and columns. For example, look at the two matrix tables in excel.

MMULT Excel - Explanation 1

In the above image, we have two matrix tables, Matrix 1 & Matrix 2. Multiplication of matrix done by using the “Dot Product” method of rows and columns, i.e., a first row of “Matrix 1” is multiplied with the first column of “Matrix 2”.

The first column of “Matrix 1” has three numbers, and the first row of “Matrix 2” has three numbers. The first number of Matrix 1 columns will be multiplied with the first number of Matrix 2 row, and like this, all the values are multiplied, and in the end, a summation of these values has arrived as a result.

This is exactly what will be done by the MMULT function in excel as well.

Syntax

MMULT Syntax

This function has two arguments, i.e., Array 1 & Array 2.

  • Array 1 will be “Matrix 1” table values and
  • Array 2 will be “Matrix 2” values.

One special note we all need to be aware of is MMULT is an array function, so after selecting the matrix 1 & matrix 2 values, we need to close the formula as an array formula by pressing CTRL + SHIFT + ENTER keys.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Array Formulas in excel Closing Keys.

Array Formula Keys

I know it is quite difficult to understand the formula logic by just reading the theoretical part, but nothing to worry about because we will show you enough examples with proper explanations to understand better.

How to Use the MMULT Function in Excel? (with Examples)

You can download this MMULT Excel Template here – MMULT Excel Template

Example #1

For example, consider below two matrices for this example.

MMULT Excel - Example 1.1

By multiplying these two Matrix, we will create “Matrix 3”. To apply the MMULT function first, we need to decide the matrix table length. This is decided by the number of rows of Matrix 1 and the number of columns if Matrix 2.

  • In this example, for Matrix 1, we have two rows, and for Matrix 2, we have two columns, so Matrix 3 will be 2 * 2 matrix. So select 2 * 2 rows and columns to create new Matrix 3.

MMULT Excel - Example 1.2

  • Step 1: Open the MMULT function.

MMULT Excel - Example 1.3

  • Step 2: For Array 1 argument, select Matrix 1 table values from A3 to C4.

MMULT Excel - Example 1.4

  • Step 3: For Array 2 argument, select Matrix 2 table values from E3 to F5.

MMULT Excel - Example 1.5

  • Step 4: Close the bracket but do not hit the enter key straight away because since this is an array formula, we need to hit the enter key by holding the Ctrl key and Shift key together. When we close the formula by holding Ctrl + Shift + Enter key, we get curly brackets as follows.

MMULT Excel - Example 1.6

So we have got the result in Matrix 3.

If you are wondering how we got these values, then we will explain it to you in detail now.

The first row values of Matrix 1 are “2, 1, 7,” and the first column values of Matrix 2 are “8, 8, 2,” and the first value of Matrix 3 is “38”. This is achieved following the below equation.

  • =(2 * 8) + (1 * 8) + (7 * 2)
  • =16 + 8 + 14 
  • = 38

Like this second value in Matrix 3 is 27, this is achieved by first row values of Matrix 1 is “2, 1, 7” and second column values of Matrix 2 is “3, 7, 2”.

  • =(2 * 3) + (1 * 7) + (7 * 2)
  • =6 + 7 + 14
  • = 27

Like this, MMULT performs its job.

Example #2

Now, look at below two equations.

Example 2.1 - Given

This time we have 3 * 3 matrix, so the new matrix will be the number of rows of Matrix 1 and the number of columns of Matrix 2. So new Matrix 3 will also be 3 * 3 matrix only.

Example 2.2 - Matrix Length

  • Now apply the MMULT function.

Example 2.3 - Enter Formula

  • Press Ctrl + Shift + Enter key to get the result.

MMULT Result

Things to Remember

  • MMULT is an array function so close with array function keys Ctrl + Shift + Enter.
  • To multiply matrix, the number of columns of Matrix 1 should be equal to the number of rows of Matrix 2; otherwise, we will get #VALUE! Error.

Recommended Articles

This has been a guide to MMULT Function in Excel. Here we discuss how to use the MMULT function to get the multiplication of a matrix with examples and a downloadable excel template. You can learn more from the following articles –

  • Covariance Matrix in Excel
  • What is Carriage Return in Excel?
  • Divide Cell in Excel
  • Matrix Multiplication in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download MMULT Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More