DIVS Function
Divides the elements in one dynamic array by those in another.
Syntax
DIVS(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 dividing the element in dynArray1 by the corresponding element in dynArray2.
Note
-
Missing or null elements in dynArray1 are treated as 0.
-
Missing or null elements in dynArray2 are treated as 1.
-
Non-numeric elements are treated as 0.
-
If an element in dynArray2 evaluates to 0, a run-time error is generated and the result is 0.
Example
ARY1 = 5:@AM:27:@AM:128
ARY2 = 2:@AM:3:@AM:64
NEWARY = DIVS(ARY1, ARY2)
Sets NEWARY to "2.5AM9AM2".