mxediv
1. Syntax:
Return Range
mxediv(Range matrix1,
Range matrix2)
Description:
Divides elements of matrix1 by elements of matrix2
and places the resulting matrix at the current cell. Matrix dimensions must be the same.
2. Syntax:
Return Range
mxediv(Range matrix1,
Cell cell2)
Description:
Divides elements of matrix1 by elements of a matrix defined by cell2
and the dimensions of matrix1.
Examples:
($a1) = mxediv($a1:$c3, $a4:$c6)
Before:
After:
0.5 | 1.33333333 | 1.75 | |
0.5 | 0.83333333 | 1 | |
0.5 | 0.66666667 | 0.75 | |
2 | 3 | 4 |
4 | 6 | 8 |
6 | 9 | 12 |
($a2) = mxediv($a1:$d4, $c6:$f9)