mxmul
Syntax:
Return
Range
mxmul
(
Range
matrix1,
Range
matrix2)
Description:
Performs matrix multiplication of
matrix1
by
matrix2
and places it at the current cell. Matrix inner dimensions must be the same.
Examples:
($a4) = mxmul($a1:$c3, $d1:$e3)
Before:
A
B
C
D
E
1
1
4
7
4
5
2
2
5
8
3
7
3
3
6
20
2
8
4
5
6
After:
A
B
C
D
E
1
1
4
7
4
5
2
2
5
8
3
7
3
3
6
20
2
8
4
30
89
0
5
39
109
0
6
70
217
0
($a2) = mxmul($a1:$d5, $a11:$c14)