Returns the matrix product of two arrays.
Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.
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})Risultato: {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.