SpreadJS 14
Formula Reference / Formula Functions / Math and Trigonometric Functions / 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)

    See Also