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:
Other People Are Reading
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.
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.
Select the collapse button next to "Array 2." Highlight cells E1 to E3, and press Enter.
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for