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

Logical functions

AND(condition1,condition2,...) AND function

ANY(test,value[,value,...]) ANY function scans a list of values

CATEGORISE("variable", "condition1", value1, "condition2", value2, ..., "conditionN", valueN [,defaultvalue] ) CATEGORISE function

IF(condition,vtrue,vfalse) IF-THEN-ELSE function

ISEMPTY(var) Cell is empty function

ISMISSING(var) Cell is missing function

ISNUMBER(var) Cell is number function

ISSTRING(var) Cell is string function

NOT(x) NOT function

ODD(x) Odd number function

OR(condition1,condition2,...) OR function

USRMISSING(var) Var is user-defined missing value

See also