Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Show menu Show menu

ANY function


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


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