# How to Solve Matrix With MS Excel

Written by james green
• Share
• Tweet
• Share
• Pin
• Email

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

## 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

#### References

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