mxscale
Syntax:
Return
Range
mxscale
(
Range
matrix1,
Number
scale)
Description:
Scales
matrix1
by
scale
and places the solution column at the current cell.
Examples:
($a4) = mxscale($a1:$c3, 3.5)
Before:
A
B
C
D
1
1
4
7
2
2
5
8
3
3
6
20
4
5
6
After:
A
B
C
D
1
1
4
7
2
2
5
8
3
3
6
20
4
3.5
14
24.5
5
7
17.5
28
6
10.5
21
70
($a2) = mxscale($a1:$d4, $f11)