Syntax: @MMUL(M1, M2)
M1 = a matrix
M2 = a matrix
@MMUL generates the product of the multiplication of matrix M2 by matrix M1. If the dimensions of the matrices are incompatible, the function generates an error.
Examples:
Matrix B9..C10 =
B | C | |
9 | 0 | 1 |
10 | 1 | 2 |
Matrix D9..E10 =
D | E | |
9 | 3 | 5 |
10 | 4 | 8 |
@MMUL(B9..C10, D9..E10) =
4 | 8 |
1 | 21 |
Matrix A1..B3 =
A | B | |
1 | 0.99 | 0 |
2 | 3 | 6.2 |
3 | 4.1 | 1.1 |
Matrix C1..E2 =
C | D | E | |
1 | 0.5 | 0.85 | 3 |
2 | 0.2 | 0.4 | 5 |
@MMUL(A1..B3, C1..E2) =
0.495 | 0.8415 | 2.97 |
2.74 | 5.03 | 40 |
2.27 | 3.925 | 17.8 |
@MMUL(A1..B3, C1..G10) = Error - incompatible matrix dimensions