Returns the matrix product of two arrays.
|array1||The first array.|
|array2||The second array.|
|* This function can return multiple values.|
* This function can create a Dynamic Array Formula.
* For an illustrated example refer to the Matrix Category page.
* "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
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top