Returns the matrix product of two arrays.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
MMULT(array1, array2)The MMULT function calculates the product of two matrices. The number of columns in array1 must be equal to the number of rows in array2, and both arrays must contain only numbers.
=MMULT({1,2;3,4}, {5,6;7,8})Result: {19, 22; 43, 50}
Multiplies a 2x2 matrix by another 2x2 matrix.
This usually happens if the number of columns in the first array does not match the number of rows in the second array.