ANY function

Synopsis
This function evaluates a condition on the elements of an array and returns true if any elements satisfy the condition.
Remarks
Variations
ANY(SourceArray, Condition)
Returns true if any elements satisfy the condition.
Details | Examples | Details and examples
Parameters
SourceArray

Specifies the array to work with.

Supported types: Boolean array; Numeric array; String array; Point array; Object array.
Condition

Specifies the condition that any element must satisfy for the function to return true.

Supported types: Boolean.
Returns
Returned types: Boolean.
Examples
1.

In the following example, at least one of the elements in the array satisfies the condition that the element be greater than 50, so the function returns true.

ANY([100, 0, -100, 5, 60], Item > 50)
2.

In this example, none of the elements are positive, so the function returns false.

ANY([0, -100, -50, -5], Item > 0)