Difference between revisions of "Manuals/calci/BITXOR"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''BITXOR(n1,n2)'''</div><br/> *where <math>n1</math> and <math>n2</math> specify the numeric values on which the bitwise XOR operation is to be p...") |
|||
| Line 20: | Line 20: | ||
== Examples == | == Examples == | ||
| − | #=BITXOR(3,5) = | + | #=BITXOR(3,5) = 6 |
#=BITXOR(17,48) = 33 | #=BITXOR(17,48) = 33 | ||
#=BITXOR(-9,-3) = 10 | #=BITXOR(-9,-3) = 10 | ||
#=BITXOR(0.5,0.1) = 0 | #=BITXOR(0.5,0.1) = 0 | ||
#=BITXOR(12, 7) = 11 | #=BITXOR(12, 7) = 11 | ||
| − | |||
==Related Videos== | ==Related Videos== | ||
Latest revision as of 13:17, 2 April 2018
BITXOR(n1,n2)
- where and specify the numeric values on which the bitwise XOR operation is to be performed.
and 
specify the numeric values on which the bitwise XOR operation is to be performed.
Description
- BITXOR() returns the result of bitwise XOR operation performed on numeric values.
- and must be greater than or equal to '0'.
- In the result, each bit position is 1 if the values of the parameters and at that bit position are not equal; in other words, one value is 0 and the other is 1.
- If either argument is a non-numeric value, BITXOR returns the #VALUE! error value.
For Example,
BITXOR(1,4) = 5
BITXOR(true, false) = 1
Examples
- =BITXOR(3,5) = 6
- =BITXOR(17,48) = 33
- =BITXOR(-9,-3) = 10
- =BITXOR(0.5,0.1) = 0
- =BITXOR(12, 7) = 11
Related Videos
See Also
References