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.