IsElement
The IsElement() function assesses whether an array contains an element.
Related functions: IsDate, IsDefined, IsNull
Syntax
IsElement (Element,Array)
| Element | Any string or numeric value |
| Array | An array of elements |
Examples
| Function | Output |
| IsElement(1,[1,2,3,4,5]) | TRUE |
| IsElement(“C”,[“A”,”B”,”C”,”D”,”E”]) | TRUE |
| IsElement(“Z”,[“A”,”B”,”C”,”D”,”E”]) | FALSE |
| IsElement(“3”,[[“A”,”B”,”C”],[1,2,3]]) | TRUE |