Manuals/calci/MMULT

From ZCubes Wiki
Revision as of 20:40, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''MMULT'''(Array1, Array2) where, '''Array1, Array2......''' - are represents arrays. </div> ---- <div ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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