Formula Functions > Functions M to Q > MMULT |
This function returns the matrix product for two arrays.
MMULT(array1,array2)
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.
Use the INDEX function to get individual elements from the returned array.
Accepts an array for all arguments. Returns an array.
MMULT(A2:B3,D5:E6)
This function is available in product version 2.0 or later.
MDETERM | MINVERSE | Math and Trigonometry Functions