ANY function

Description

ANY(test,value[,value,...]) returns 1 (=TRUE) if the value of test matches any of the subsequent values; returns 0 (=FALSE) otherwise.

Examples

ANY(var, 1, 3, 7) returns 1 if the value of var is 1, 3, or 7 and 0 for other values.

ANY(1,var1,var2,var3) returns 1 if any of the three specified variables has a value of 1 and 0 if all three variables have values other than 1.

Related functions

• List of Logical functions