MMULT

MMULT(array1, array2)

Returns the matrix product of two arrays.

array1	The first array.
array2	The second array.

REMARKS

* For an illustrated example refer to the Matrix Category page.
* This function can return multiple values.
* This function can create a Dynamic Array Formula.
* "array1" and "array2" are the arrays you want to multiply.
* The number of columns in "array1" must be the same as the number of rows in "array2", and both arrays must contain only numbers.
* The result is an array with the same number of rows as "array1" and the same number of columns as "array2".
* "array1" and "array2" can be given as cell ranges, array constants, or references.
* If any of the arguments are not numeric, then #VALUE! is returned.
* If any cells are empty or contain text, then #VALUE! is returned.
* If the number of columns in "array1" is different from the number of rows in "array2", then #VALUE! is returned.
* You can use the MDETERM function to return the matrix determinant of an array.
* You can use the MINVERSE function to return the inverse matrix of an array.
* You can use the TRANSPOSE function to returns an array with its orientation changed.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A	B	C
1	=MMULT({3}, {4}) = 12	2	4
2	=MMULT(B1, B2) = 8	4	2
3	{=MMULT(B1:C2,B1:C2)} = { {20,16},{16,20} }
4	{=MMULT({1,3;7,2}, {2,0;0,2}) } = { {2,6},{14,4} }