BITNOT function

Microsoft Office ShapeSheet

BITNOT function

See also

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)

Example

BITNOT(6)

Returns 65529. The 6 = 0...00110. Therefore, BITNOT(6) = 1...11001.