Microsoft Visio 2010 Business Process Diagramming and Validation

Useful ShapeSheet functions

This is a table of the ShapeSheet functions that are commonly used in 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 ...