MULS Function
Multiplies the elements in two dynamic arrays.
Syntax
MULS(dynArray1, dynArray2)
Syntax Elements
dynArray1, dynArray2
DataBasic expressions
that evaluate to dynamic arrays.
Return Value
A dynamic array formed by combining dynArray1 and dynArray2. Each element contains the result of multiplying the corresponding elements in the original arrays.
Note
-
Missing or null elements in the original arrays are treated as 0.
-
Non-numeric elements are treated as 0 and a run-time error is generated (see Strings in Arithmetic Expressions).
Example
ARY1 = 1:@AM:2:@AM:7
ARY2 = 1:@AM:1
NEWARY = MULS(ARY1, ARY2)
Sets NEWARY to "1AM2AM0". The missing third element in ARY2 is treated as 0, so the third element in the result is also 0.