How to Solve Matrix With MS Excel

Written by james green
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Solve Matrix With MS Excel
The MMULT function in Excel is used for multiplying matrices. (keyboard image by Andrey Kurehin from

When faced with a system of equations, it is often easier to solve them using a matrix operator instead of solving them one by one. Microsoft Excel contains a function called MMULT which may be used to multiply matrices. In this example, a 3x3 matrix is filled into cells A1 to C3 and a 3x1 matrix is filled into cells E1 to E3 and then multiplied.

Skill level:


  1. 1

    Highlight cells G1 to G3 on your spreadsheet. These cells will contain the solution to the matrix multiplication. Without clicking anything, type in "=" without the quote marks.

  2. 2

    Click on the "Formulas" tab, select the "Math & Trig" button, and select "MMULT" from the sub-menu. The "Function Arguments" dialogue will open. Select the collapse button next to "Array 1" (the red arrow), highlight cells A1 to C3, and press Enter.

  3. 3

    Select the collapse button next to "Array 2." Highlight cells E1 to E3, and press Enter.

  4. 4

    Instead of clicking "OK" in the "Function Arguments" dialogue, hold down Control (Ctrl), Shift, and press Enter. This will calculate the multiplication of your two matrices.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.