SUBS Function

Subtracts the elements in one dynamic array from those in another.

Syntax

SUBS(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 subtracting the element in dynArray1 from the corresponding element in dynArray2.

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 = 5:@AM:27
ARY2 = 2:@AM:3:@AM:64
NEWARY = SUBS(ARY1, ARY2)

Sets NEWARY to "3AM24AM-64". Because there are only two elements in ARY, the third element (64) in ARY2 is subtracted from 0.