IN
Description
Determines whether a value or list of values that you specify is in another list of
values. If so, returns True; otherwise, returns False.
Syntax
IN(
source
,
target
)
- source: The number or list of numbers.
- target: The array of target values.
Example
Formula | Result |
|---|---|
=IN(5,{1,2,3,4,5}) | TRUE |
=IN({"a","b"},{"d","c","b","a"}) | TRUE |