To use this function, choose Calc > Calculator.

Returns a 1 if a value equals any value from a set of values, returns a 0 if not.



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
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy