MMult

Syntax

MMult(A1, A2)

Parameters

A1. The range of cells that contain a numeric array.

A2. The range of cells that contain a numeric array.

The number of columns in the array transferred within the A1 parameter must match the number of rows in the array transferred within the A2 parameter.

NOTE. To define the range, specify the addresses of the upper left and the lower right cells where the matrix is located.

Description

It returns the product of matrices.

Comments

The result is an array with the same number of rows as A1 and the same number of columns as A2.

The function returns the array that is why it should be inserted as an array formula.

The MMult function returns an error value if:

Example

The source matrices (see above) and their product (see below) look as follows:

Formula Result Description
=MMult(A0:B3, D0:G1) See the image. The product of the above given matrices.

The formula in this example is to be entered as an array formula. To do this:

  1. Enter the formula into the cell.

  2. Select a range with the size equal to size of the source matrix, starting with the cell that contains the formula.

  3. Press F2 and then CTRL+SHIFT+ENTER.

If the formula is not entered as an array formula, the value of inverse matrix is displayed.

See also:

Function WizardMathematical FunctionsMDetermMInverse