The matrix equation is solved by multiplying both sides of the equation by the inverse of the matrix. Thus our next job is to find the inverse of the matrix. The Excel function for inverting a matrix is MINVERSE(). MINVERSE() is what Excel calls an "array formula" -- that is, the answer requires more than one cell. The inverse of a 3-by-3 matrix is another 3-by-3 matrix. So first you must highlight an area 3 columns wide and 3 rows wide of empty Excel cells. (I highlighted E8:G10, that's how you refer to rectangular ranges in Excel the upper left cell and the lower right cell separated by a colon.) Then you enter the =MINVERSE(A8:C10) in the formula bar. And Press CTRL+SHIFT+ENTER.

NEXT
BACK