اگر  ۲X+۳Y=3    ,   5X-Y=8    باشد  X و Y را بیابید :

ماتریس ضرایب A  و ماتریس متغیرها X  و ماتریس جواب B  .

با استفاده  از تابع   MINVERSE  معکوس ماتریس را میابیم :

MINVERSE

Returns the inverse matrix for the matrix stored in an array.

Syntax

MINVERSE(array)

Array    is a numeric array with an equal number of rows and columns.

Remarks

• Array can be given as a cell range, such as A1:C3; as an array constant, such as {1,2,3;4,5,6;7,8,9}; or as a name for either of these.

• If any cells in array are empty or contain text, MINVERSE returns the #VALUE! error value.

• MINVERSE also returns the #VALUE! error value if array does not have an equal number of rows and columns.

• Formulas that return arrays must be entered as array formulas.
• Inverse matrices, like determinants, are generally used for solving systems of mathematical equations involving several variables. The product of a matrix and its inverse is the identity matrix— the square array in which the diagonal values equal 1, and all other values equal 0.
• As an example of how a two-row, two-column matrix is calculated, suppose that the range A1:B2 contains the letters a, b, c, and d that represent any four numbers. The following table shows the inverse of the matrix A1:B2.

  	Column A	Column B
  Row 1	d/(a*d-b*c)	b/(b*c-a*d)
  Row 2	c/(b*c-a*d)	a/(a*d-b*c)

• MINVERSE is calculated with an accuracy of approximately 16 digits, which may lead to a small numeric error when the cancellation is not complete.
• Some square matrices cannot be inverted and will return the #NUM! error value with MINVERSE. The determinant for a noninvertable matrix is 0.

 حال برای محاسبه نهایی باید معکوس ماتریس را در ماتریس جواب ضرب کنیم ، تابع حاصل ضرب ماتریس  MMULT  است .

توجه داشته باشید هر دوی این توابع آرایه ای هستند و باید CTRL +SHIFT+ENTER  را بجای ENTER استفاده کرد .

طریقه استفاده از تابع  minverse  :