mxadd
1. Syntax:
Return Range
mxadd(Range matrix1,
Range matrix2)
Description:
Adds matrix1 to matrix2
and places the resulting matrix at the current cell. Matrix dimensions must be the same.
2. Syntax:
Return Range
mxadd(Range matrix1,
Cell cell2)
Description:
Adds matrix1 to a matrix defined by cell2
and the dimensions of matrix1.
Examples:
($a1) = mxadd($a1:$c3, $a4)
Before:
After:
3 | 7 | 11 | |
6 | 11 | 16 | |
9 | 15 | 21 | |
2 | 3 | 4 |
4 | 6 | 8 |
6 | 9 | 12 |
($a2) = mxadd($a1:$d4, $c6:$f9)