이 함수는 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.