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.

Syntax

ANY(test,constant,constant,...)

For test, specify the column number. For constant, specify the value or values to identify in the results column.

Example

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