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
ISUNIQUE([listID,]var) IsUnique function
NOT(x) NOT function
ODD(x) Odd number function
OR(condition1,condition2,…) OR function
USRMISSING(var) Var is user-defined missing value