Welcome back to our frequent blog of Excel functions from A to Z. Today we look at the Scathing function.
The BITOR function
I'm starting to get used to these functions now, good, a LITTLE BIT anyway (Do you understand?). This function returns a bitwiseO'Of two numbers. In this variant, this means that the The value of each bit position (the respective number that is read from right to left when represented in binary) it is counted if any of the parameter bits in that position is 1.
The BITOR The function uses the following syntax to operate:
The Scathing The function has the following arguments:
- number 1: this is mandatory and must be in decimal format, greater or equal to 0
- Number 2: additionally required. It must be in decimal form and be greater than or equal to 0.
It should be noted at the same time that:
- the result is bit by bit ‘O‘Of its parameters
- in the result, each bit position is 1 if any of the parameter bits in that position is 1
- the return values of the bit positions progress from right to left as powers of 2. The bit on the right returns 1 (2 ^ 0), the left bit returns 2 (2 ^ 1), and so on
- if any of the arguments are outside your limitations, BITOR return the #ON ONE! error value
- if any of the arguments is greater than (2 ^ 48) -1, Scathing return the #ON ONE! error value
- if any of the arguments is a non-numeric value, Scathing return the #VALUE! error value.
Please, see my example below: