Useful ShapeSheet functions

This is a table of the ShapeSheet functions that are commonly used in the Filter Expression and Test Expression formulae:

Function	Description
AND(logical expression1,logical expression2,...,logical expressionN)	Returns TRUE (1) if all of the logical expressions supplied are true. If any of the logical expressions are false or 0, the AND function returns FALSE (0).
OR(logicalexpression1,logicalexpression2,...,logicalexpressionN)	Returns TRUE (1) if any of the logical expressions are true.
NOT(logicalexpression)	Returns TRUE (1) if logicalexpression is false. Otherwise, it returns FALSE (0).
IF(logicalexpression,valueiftrue,valueiffalse)	Returns valueiftrue if logicalexpression is true. Otherwise, it returns valueiffalse.
INDEX(index,"list"[,[delimiter][,[errorvalue]]])	Returns the substring at the zero-based location index in the list delimited-by-delimiter. Or, it returns -1 if not found.
LOOKUP("key","list...