No in Excel per se, to my knowledge. But there is an XOR operator in VBA.
For example:
Function myxor(lh as Long, rh as Long) as Long
myxor = lh Xor rh
End Function
When we enter =myxor(12,10), the result is 6. Note that 12 in binary is
1100, 10 is 1010, and 6 is 0110. However, keep in mind that Excel stores
numbers internally as binary floating-point.
The above function is limited to 31-bit positive integers. You can use
32-bit integers by treating them as signed integers.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
