A formula in which the individual values in a cell range are evaluated is referred to as an array formula.The smallest possible array is a 1 x 2 or 2 x 1 array, with two adjacent cells. For example, a square range of three rows by three columns is a 3 x 3 array. An array is a rectangular range of cells containing data."/" is the division key on the numeric keypad. Select all cells in an array formula range. Mapping between relevant Windows/Linux and macOS key combinations The following table shows the mapping between these key combinations and their macOS equivalents. To avoid repetition within the subsequent text, only Windows/Linux key combinations are specified. General information about Calc's array functionsįor convenience, the information in this subsection is repeated on all pages describing Calc's array functions. In this case, the result of the matrix multiplication will be an m x p matrix. Assuming that the Array 1 argument is an m x n matrix, then for the Array 2 argument to be compatible for matrix multiplication it must be an n x p matrix.If any cell within either Array 1 or Array 2 is empty or contains non-numeric data, then MMULT reports a #VALUE! error.Īdditional details: Details specific to MMULT function.If the number of columns in Array 1 is not equal to the number of rows in Array 2, then MMULT reports an invalid argument error (Err:502).The tilde (~) reference concatenation operator cannot be used to join multiple areas in these arguments. If either Array 1 or Array 2 is not a single area reference, then MMULT reports an invalid argument error (Err:502).For the supplied matrices to be compatible for matrix multiplication, the number of columns in Array 1 must be the same as the number of rows in Array 2. This argument can take the form of an explicit cell range (such as A1:C3), the name of a named range, the name of a database range, or an inline constant array. This argument can take the form of an explicit cell range (such as A1:C3), the name of a named range, the name of a database range, or an inline constant array.Īrray 2 contains the second matrix to be used in the multiplication. Returns an array of numbers representing the matrix product, having the same number of rows as the first argument and the same number of columns as the second argument.Īrray 1 contains the first matrix to be used in the multiplication. Calculates the third matrix produced by applying matrix multiplication to two compatible matrices.
0 kommentar(er)
