Difference between revisions of "Manuals/calci/BITOR"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
== Description == | == Description == | ||
| − | * | + | *BITXOR() returns the result of bitwise XOR operation performed on numeric values. |
| − | *<math>n1</math> and <math>n2</math> must be | + | *<math>n1</math> and <math>n2</math> must be greater or equal to '0'. |
| − | * | + | *In the result, each bit position is 1 if the values of the parameters <math>n1</math> and <math>n2</math> 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, | + | *If either argument is a non-numeric value, BITXOR returns the #VALUE! error value. |
For Example, | For Example, | ||
| − | + | BITXOR(1,6) = '''7''' | |
| − | + | BITXOR(true, true) = '''0''' | |
== Examples == | == Examples == | ||
| − | #= | + | #=BITXOR(3,5) = 6 |
| − | #= | + | #=BITXOR(17,-22) = -5 |
| − | #= | + | #=BITXOR(-9,-3) = 10 |
| − | #= | + | #=BITXOR(0.5,0.1) = 0 |
| − | #= | + | #=BITXOR(12, 7) = 11 |
| Line 34: | Line 34: | ||
==See Also== | ==See Also== | ||
| + | *[[Manuals/calci/BITOR | BITOR]] | ||
*[[Manuals/calci/BITAND | BITAND]] | *[[Manuals/calci/BITAND | BITAND]] | ||
*[[Manuals/calci/BITNOT | BITNOT]] | *[[Manuals/calci/BITNOT | BITNOT]] | ||
Revision as of 06:06, 4 May 2017
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 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,6) = 7
BITXOR(true, true) = 0
Examples
- =BITXOR(3,5) = 6
- =BITXOR(17,-22) = -5
- =BITXOR(-9,-3) = 10
- =BITXOR(0.5,0.1) = 0
- =BITXOR(12, 7) = 11
Related Videos
See Also
References