IN

Returns a boolean indicating if a specified item (needle) is inside of a given set (haystack). Note that the haystack must be an array.

Syntax

=IN(haystack, needle)

Examples

=IN([1,2,3], 1)→true
=IN([1,2,3], 0)→false
=IN([OBJECT("A", 1), OBJECT("B", 1)], OBJECT("A", 1))→true
=IN([OBJECT("A", 1), OBJECT("B", 1)], OBJECT("A", "B"))→false