Returns the matrix product of two arrays.
פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-Excel — אותה תחביר ואותם ארגומנטים.
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})תוצאה: {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.