MMULT ( array-1 , array-2 )
Description: Computes the product of the matrices of numbers designated by array-1 and array-2.
Mathematical Formula:
The matrix product array a of two arrays b and c is:
where i is the row number, and j is the column number.
Arguments:
|
Name |
Type |
Description |
|
array-1 |
Designate the matrices of numbers to be multiplied. | |
|
array-2 |
Return Type and Value: number – The product of the matrices of numbers designated by array-1 and array-2.
However, if
• Any cells in array-1 or array-2 are empty or contain text, the return value is unspecified.
• The number of columns in array-1 is different from the number of rows in array-2, #VALUE! is returned.
[Example:
MMULT({3,6,1;1,1,0},{5,7;4,6;2,5}) results in 41
end example]