Manuals/calci/MMULT
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 |
