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
Search JabSto ::

Custom Search