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

• The MedCalc spreadsheet
• Spreadsheet functions