BITXOR Functioon

how to use bitxor function in excel


BITXOR is a bitwise operation which returns a decimal number of two bitwise XOR operation.

Syntax


=BITXOR(number1, number2)

Arguments

number1: First numerical value for BITXOR operation 
number2: Second numerical value for BITXOR operation


Behavior


We have taken an example for bitwise operation first four numbers are shown how operation perform in bitwise XOR

If number 1 and number 2 are "1" and/or "0" (Both are same) than BITXOR returns "0" otherwise it will return "1"

in last row you can see we have taken number1 as "11" and number 2 as "12" and BITXOR returns "7".

See How                                             8 4 2 1
in the binary system, 11 is written as 1 0 1 1
and                            12 is written as 1 1 0 0 
So here BITXOR Function will give you the number where "1" and "0" is present it is"7"

Usage


BITXOR is used to bitwise calculation in digital programming.


Returns

Decimal number evaluated by bitwise operation


Note:

Number1 and number 2 should not be greater than (2^48)-1

No comments:

Post a Comment