MMULT function

MMULT(matrix1, matrix2) MMULT(matrix1; matrix2)

matrix1 — {{ Number }}

The numbers of the first matrix. This two-dimensional array must be a rectangle, with no blank values. The sizes of its constituent arrays must be equal to the size of the array representing the second matrix. In other words, the number of columns of this matrix must be equal to the number of rows of the second matrix.

matrix2 — {{ Number }}

The numbers of the second matrix. This two-dimensional array must be a rectangle, with no blank values. The size of this array must be equal to the sizes of the constituent arrays of the array representing the first matrix. In other words, the number of rows of this matrix must be equal to the number of columns of the first matrix.

Returns — {{ Number }}

The matrix product of the two matrices.

Returns the matrix product of the given matrices. Matrices are written differently in Calcapp compared to most spreadsheets. For instance, =MMULT({ 3, 5; 1, 2 }, { 2, 6; 1, 1 }) (written =MMULT({ 3; 5\ 1; 2 }; { 2; 6\ 1; 1 }) with decimal commas) is written as MMULT({{ 3, 5 }, { 1, 2 }}, {{ 2, 6 }, { 1, 1 }})MMULT({{ 3; 5 }; { 1; 2 }}; {{ 2; 6 }; { 1; 1 }}) in Calcapp.

Example

MMULT({{ 3, 5 }, { 1, 2 }}, {{ 2, 6 }, { 1, 1 }})MMULT({{ 3; 5 }; { 1; 2 }}; {{ 2; 6 }; { 1; 1 }})

Returns the matrix products of the given matrices, {{ 11, 23 }, { 4, 8 }}{{ 11; 23 }; { 4; 8 }}.