The
MMULT() function calculates the
product of two arrays.
- The syntax for the function
is MMULT(array_1, array_2).
The
arguments "array_1" and "array_2" can
be an array of numerical values, references
to a range of cells or a named range of
which you want to find product. If the
number of columns "array_1"is
different from the number of rows in "array_2" or
the number of elements in the resulting
array
is greater than 5,461 cells a #VALUE error
will be returned.
The
MMULT function multiplies the two arrays
returning a resulting array For example:
MMULT({6,2:4,1},{8,5:9,2}) = {66,34:41,22}.The
first element of the resultant array is
created by multiplying each element in
the first row of the first array by each
element in the first column of the second
array. i.e. (6*8+4*2) = (48+18) = 66. The
second element is created by multiplying
each of element in the first
row of the first array by each element
in the second column of the second matrix
giving (6*5+2*2) =34 and the patterns continues
for each resultant element (4*8+1*9)= 41
and (4*5+1*2) =22. The same pattern is also
used for larger arrays.
To learn more about multiplying matrices
or "arrays" in
mathematics see: [The Multiplying Matrices
Mathematics Knowledgebase].
[The
MINVERSE() function knowledgebase]
[The MDETERM() function knowledgebase]
[The TRANSPOSE() function knowledgebase]
|
