Spread Formula Reference
Formula Functions / Functions M to Q / MMULT
In This Topic
    MMULT
    In This Topic

    This function returns the matrix product for two arrays.

    Syntax

    MMULT(array1,array2)

    Arguments

    The arrays are numeric arrays where the columns in array1 match the rows in array2.

    Arrays can be a cell range. If any of the array cells are empty or contain text then an error is returned.

    Remarks

    Use the INDEX function to get individual elements from the returned array.

    Data Types

    Accepts an array for all arguments. Returns an array.

    Examples

    MMULT(A2:B3,D5:E6)

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    MDETERM | MINVERSE | Math and Trigonometry Functions