Microsoft Office Tutorials and References

In Depth Information

**Solving Simultaneous Equations**

2.
Place the coefficients in an
n-by-
n range of cells, where
n represents the number of

equations.

In Figure 128-1, the coefficients are in the range I2:J3.

3.
Place the constants (the numbers on the right side of the equal sign) in a vertical range

of cells.

In Figure 128-1, the constants are in the range L2:L3.

4.
Use an array formula to calculate the inverse of the coefficient matrix.

In Figure 128-1, the following array formula is entered into the range I6:J7. (Remember to

press Ctrl+Shift+Enter to enter an array formula.)

=MINVERSE(I2:J3)

5.
Use an array formula to multiply the inverse of the coefficient matrix by the constant

matrix.

In Figure 128-1, the following array formula is entered into the range J10:J11. This range

holds the solution (x = 7.5, and y = –3.625).

=MMULT(I6:J7,L2:L3)

Figure 128-2 shows a worksheet set up to solve a set of three simultaneous equations.

Figure 128-2:
Using formulas to solve a set of three simultaneous equations.