Documentation/Calc Functions/MMULT

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

MMULT

Category:

Array

Summary:

Calculates the array product of two arrays. The number of columns for array 1 must match the number of rows for array 2. The square array has an equal number of rows and columns.

Syntax:

MMULT(Array; Array)

Returns:

Arguments:

Array at first place represents the first array used in the array product.

Array at second place represents the second array with the same number of rows.

Additional details:

More explanations on top of this page.

Examples:

Select a square range. Choose the MMULT function. Select the first Array, then select the second Array. Using Function Wizard, mark the Array check box. Click OK. The output array will appear in the first selected range.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: