Syntax
=MMULT(array1, array2)Arguments
| Argument | Required | Description |
|---|---|---|
array1 | Required | The first matrix |
array2 | Required | The second matrix (its rows must equal the columns of array1) |
How to use MMULT
When MMULT returns more than one value, the result spills into the cells below and to the right. Keep those cells empty, or you get #SPILL!.
MMULT takes 2 required arguments. Type =MMULT( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=MMULT({1,3;7,2}, {2,0;0,2})Result Spilled result
| A | B | |
|---|---|---|
| 1 | 2 | 6 |
| 2 | 14 | 4 |
=MMULT({1,2,3}, {4;5;6})Result =MMULT({1,2}, {1,2})Result Related math functions
- LOG10Returns the base 10 logarithm of a number.
- MDETERMReturns the determinant of a square matrix.
- MINUSReturns the difference of two numbers, like the - operator.
- MINVERSEReturns the inverse of a square matrix.
- MODReturns the remainder after dividing a number by a divisor; the result has the sign of the divisor.
- MROUNDRounds a number to the nearest multiple of another number.
- MULTINOMIALReturns the factorial of a sum of values divided by the product of their factorials.
- MULTIPLYReturns the product of two numbers, like the * operator.
- MUNITReturns the identity matrix of a given size.