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

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

See also

• Spreadsheet: Introduction
• Spreadsheet functions