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
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
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
Select the collapse button next to "Array 2." Highlight cells E1 to E3, and press Enter.

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