Main page /  Useful info about ShapeSheet™  / Visio ShapeSheet reference / ShapeSheet™. List of functions by category

ShapeSheet. Category Logic functions

Note

This table contain only functions which included in table for similar category in the book MS Visio 2003 Developer’s Survival Pack by Graham Wideman (see chapter 37).

The version information in which the function was added is taken from John's Goldsmith article Visio ShapeSheet Functions by Version


Name

Details

AND

Version Added: Pre 2003

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).

Syntax

AND(logical expression1,logical expression2,...,logical expressionN)

Read more about function AND

BITAND

Version Added: Pre 2003

Returns a 16-bit binary number in which each bit is set to 1 only if the corresponding bit in both binarynumber1 and binarynumber2 is 1. Otherwise, the bit is set to 0.

Syntax

BITAND(binarynumber1,binarynumber2)

Read more about function BITAND

BITNOT

Version Added: Pre 2003

Returns a 16-bit binary number in which each bit is set to 1 only if the corresponding bit in binary number is 0. Otherwise, the bit is set to 0.

Syntax

BITNOT(binary number)

Read more about function BITNOT

BITOR

Version Added: Pre 2003

Returns a 16-bit binary number in which each bit is set to 1 if the corresponding bit in either binary number1 or binary number2 is 1. The bit is set to 0 only if the corresponding bit is 0 in both binary number1 and binary number2.

Syntax

BITOR(binary number1,binary number2)

Read more about function BITOR

BITXOR

Version Added: Pre 2003

Returns a 16-bit binary number in which each bit is set to 1 if the corresponding bit in either but not both binary number1 and binary number2 is 1. Otherwise, the bit is set to 0.

Syntax

BITXOR(binary number1,binary number2)

Read more about function BITXOR

NOT

Version Added: Pre 2003

Returns TRUE (1) if logicalexpression is FALSE. Otherwise, it returns FALSE (0).

Syntax

NOT(logicalexpression)

Read more about function NOT

OR

Version Added: Pre 2003

Returns TRUE (1) if any of the logical expressions passed as parameters are TRUE.

Syntax

OR(logicalexpression1,logicalexpression2,...,logicalexpressionN)

Read more about function OR