Name

MMULT

Synopsis

You can use MMULT to find the product of two matrices.

To Calculate

=MMULT(Array1, Array2)

Both of the arguments must be specified for this function. For this function to work, Array1 must have the same number of columns as the number of rows in Array2.

Array1, Array2

Specifies an array that contains only numeric values.

Example

Figure 14-13 illustrates how to use MMULT to find the product of two matrices. The example also shows how MDETERM can find the determinant of each matrix and MINVERSE is used to find the inverse of each square matrix.

Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.