Investment Studio > Expressions > Functions > Matrix > MMULT
float array[rows_a][columns_b] mmult(float array[rows_a][n] a, float array[n][columns_b] b)
Returns the matrix product of float arrays a and b. The number of columns in a must equal the number of rows in b.
Non-numeric array elements are automatically converted to numbers. If conversion fails, they are treated as zeros.
Equivalent to the multiplication operator (*) with array operands.
The result is an array with the same number of rows as a and the same number of columns as b.
Example
=mmult({{1, 2}, {3, 4}, {5, 6}}, {{7, 8, 9}, {10, 11, 12}})
equals {{27, 30, 33}, {61, 68, 75}, {95, 106, 117}}
=mmult({{1, 2}, {3, 4}, {5, 6}}, {{"7", "8", "9"}, {"", "11", "12"}})
equals {{7, 30, 33}, {21, 68, 75}, {35, 106, 117}}.