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 Fotolia.com)

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:
Moderate

Other People Are Reading

Instructions

  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

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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