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.

Search JabSto ::

Custom Search