Translations:Documentation/Calc Functions/BITXOR/18/en

    From The Document Foundation Wiki
    Formula Description Returns
    =BITXOR(6;10) 6 in binary is 0110 and 10 in binary is 1010 so
    (0110 ^ 1010 = 1100)
    12 (1100)
    =BITXOR(6.123;10) floor value of 6.123 is taken so 6 in binary is 0110 and 10 in binary is 1010 so
    (0110 ^ 1010 = 1100)
    12 (1100)
    =BITOR(123;156) 123 in binary is 01111011 and 156 in binary is 10011100 so
    (0110 ^ 1010 = 11100111)
    231 (11100111)
    =BITXOR(123; 2^48 + 5) number 2 argument is greater than 2^48 hence it will return an error Err:502
    =BITXOR(123; -5) number 2 argument is negative hence it will return an error Err:502