To use this function, choose .
Returns a 1 if a value equals any value from a set of values, returns a 0 if not.
ANY(test,constant,constant,...)
For test, specify the column number. For constant, specify the value or values to identify in the results column.
To identify instances of the value 3 in C1, enter the expression ANY(C1,3) and store the results in C2.
C1 | C2 |
---|---|
6 | 0 |
3 | 1 |
2 | 0 |
3 | 1 |
5 | 0 |