Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Skip to main content
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

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

This site uses cookies to store information on your computer. More info...