Microsoft Office Tutorials and References

In Depth Information

**MINVERSE**

MDETERM({1,2;3,4})
equals –2. Thus, each element of the array argument must be a numeric

value or an error value is returned.

The
ARRAY
argument is a numeric array that must have an equal

number of rows and columns or an error value is returned.

ARRAY

MINVERSE

The
MINVERSE
function returns the inverse matrix for the matrix stored in an array.

=MINVERSE(array)

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.

The determinant for a noninvertible matrix is 0. For example,
MINVERSE({1,2,1;4,1,2;3,

3,1})
equals
{–0.625,0.125,0.375;0.25,–0.25,0.25;1.125,0.375,–0.875}
.

The
ARRAY
argument is a numeric array that must have an equal

number of rows and columns, which can be given as a cell range—

for example, A1:C3; as an array constant, such as {1,2,3;4,5,6;7,8,9};

or as a name to either of these. Functions that return arrays must

be entered as array formulas (by pressing Ctrl+Shift+Enter).

ARRAY

You can use the
INDEX
function to return individual items from a matrix created by functions such as

MINVERSE
. For example,
INDEX(matrix,1,1)
will return the value from the upper-left corner of an

array named “matrix”.

TIP

MMULT

The
MMULT
function returns the matrix product of two arrays. The result is an array with the

same number of rows as
array1
and the same number of columns as
array2
.

=MMULT(array1,array2)

array1
and
array2
can be given as cell ranges, array constants, or references. If any cells are

empty or contain text, or if the number of columns in
array1
is different from the number of

rows in
array2
,
MMULT
returns an error value. Functions that return arrays must be entered

as array formulas (by pressing Ctrl+Shift+Enter). For example:
MMULT({1,2;3,1},{2,2;3,-

1})
equals
{8,0;9,5}
.

ARRAY
The
array1
and
array2
arguments are the arrays you want to

multiply. The number of columns in
array1
must be the same as the

number of rows in
array2
, and both arrays must contain only numbers.

The matrix product array a of two arrays b and c is