The following bitwise arithmetic functions are provided in the Real Statistics Resource Pack with functionality similar to the standard Excel functions BITAND, BITOR, BITXOR, BITLSHIFT and BITRSHIFT that were introduced with Excel 2013. These new Real Statistics functions may be useful to Excel 2007, 2010 and 2011 users.
Worksheet Functions
Real Statistics Functions: The Real Statistics Resource Pack contains the following functions.
BIT_AND(m, n) = bitwise And of the binary values of the integers m and n
BIT_OR(m, n) = bitwise Or of the binary values of the integers m and n
BIT_AND(m, n) = bitwise Xor of the binary values of the integers m and n
BIT_LSHIFT(m, shift) = bitwise result of shifting the binary equivalent of the integer m shift units to the left (if omitted, shift defaults to 1)
BIT_RSHIFT(m, shift) = bitwise result of shifting the binary equivalent of the integer m shift units to the right (if omitted, shift defaults to 1)
Examples
Examples: Figure 1 shows how to use these functions. Note that BIN2DEC is a standard Excel function that converts a text string containing a binary number into the equivalent decimal value. Similarly, DEC2BIN is a standard Excel function that converts a decimal number representing a positive integer into a text string containing a binary number.
Figure 1 – Bitwise arithmetic examples
Examples Workbook
Click here to download the Excel workbook with the examples described on this webpage.
Reference
Microsoft (2019) BITRSHIFT function
https://support.microsoft.com/en-us/office/bitrshift-function-274d6996-f42c-4743-abdb-4ff95351222c