SpreadJS Documentation
BITXOR
SpreadJS Documentation > Formula Reference > Formula Functions > BITXOR

This function returns bitwise XOR of the two specified numbers.

Syntax

BITXOR(value1, value2)

Arguments

For the arguments of this function, both values must be in decimal form and greater than or equal to 0.

Remarks

In this function, if value of any parameter's bits at same position is not equal only then the value of each bit position is counted.

Data Types

Accepts decimal form of data. Returns decimal form of data.

Examples

BITXOR(6,2) gives the result 4.

BITXOR(8,3) gives the result 11.

See Also