Manuals/calci/MMULT
Jump to navigation
Jump to search
MMULT(Array1, Array2)
where,
Array1, Array2...... - are represents arrays.
It returns the matrix product of two arrays.
Formula :-
MMULT = Σbikckj
If Array1, Array2......... have different set of data points , MMULT returns #ERROR.
If any cell is empty, returns NaN.
MMULT
Lets see an example in (Column2, Row5)
=MMULT(R1C1:R2C2, R3C1:R4C2)
MMULT returns array[23,47,30,62].
Syntax
Remarks
Examples
Description
Column1 | Column2 | Column3 | Column4 | |
Row1 | 1 | 5 | ||
Row2 | 2 | 6 | ||
Row3 | 3 | 7 | ||
Row4 | 4 | 8 | ||
Row5 | 23,47,30,62 | |||
Row6 |