Recall that you begin an array formula by highlighting the range of cells that will contain the results of the array formula. You then type in the array formula and finish with the Ctrl-Shift-Enter key combination. If you forget and just tap the Enter key when you are done, you'll have to start all over again.
1. Highlight the three cells that contain calculated results (G4:G6).
2. Start the array formula by entering:
=MMULT(
3. Use the mouse to highlight the array of cells containing the coefficients (E4:F6).
4. Enter a comma (which separates the two arguments of the MMULT function).
5. Highlight the array of cells containing the values of the variables (B4:B5).
6. Enter the closing parenthesis. At this point, you should have:
=MMULT(E4:F6,B4:B5)
7. Finish with the Shift-Ctrl-Enter keystroke combination.
Your array formula performs the following calculation:
