BITOR

Formulas / BITOR
Return a decimal number representing the bitwise OR of two numbers.
=BITOR(number1,number2)
  • number1 - required argument in decimal form, not less than 0
  • number2 - required argument in decimal form, not less than 0

Examples

  • =BITOR(23,10)

    The BITOR function can be used to compare two binary numbers and return the result of their comparison. For example, this formula compares the bit positions of the binary representations of 23 and 10 and returns 2 raised to a power if either position has 1, summing the numbers to return 31.

  • =BITOR(7,5)

    The BITOR function can also be used to compare two decimal numbers and return the result of their comparison. For example, this formula compares the bit positions of the binary representations of 7 and 5 and returns 2 raised to a power if either position has 1, summing the numbers to return 7.

  • =BITOR(0b1101, 0xA)

    The BITOR function can be used to compare two numbers in different bases and return the result of their comparison. For example, this formula compares the bit positions of the binary representations of 1101 and 10 and returns 2 raised to a power if either position has 1, summing the numbers to return 15.

  • =BITOR(111111, 11)

    The BITOR function can be used to compare two numbers of different lengths and return the result of their comparison. For example, this formula compares the bit positions of the binary representations of 111111 and 11 and returns 2 raised to a power if either position has 1, summing the numbers to return 111111.


Summary

The BITOR function is a tool that allows users to take two decimal numbers and apply a bitwise OR operation to them, returning the result. Both the first and second argument must be greater than or equal to 0.

  • The BITOR function returns a decimal number representing the bitwise OR of two numbers, provided they are positive and not larger than 2^48 - 1.
  • The BITOR function only takes two arguments, which must be positive decimal numbers greater than or equal to zero.
  • The BITOR function can be used to return the bitwise OR of two numbers.

Frequently Asked Questions

What is the BITOR function?
The BITOR function is a function in Sourcetable that returns a bitwise "OR" of two numbers.
What is the syntax of the BITOR function?
The syntax of the BITOR function is BITOR(number1, number2).
What are the arguments of the BITOR function?
The arguments of the BITOR function are number1 and number2.
Are both arguments required for the BITOR function?
Yes, both arguments are required for the BITOR function.
What is the format of the arguments for the BITOR function?
The number1 argument is in decimal form and the number2 argument is also in decimal form.
What does the BITOR function return?
The BITOR function returns a bitwise "OR" of its arguments.
What error does the BITOR function throw when either argument is not within the constraints?
The BITOR function throws a #NUM! error if either argument is not within the constraints.
Does the BITOR function throw an error when either argument is not a numeric value?
Yes, the BITOR function throws an error if either argument is not a numeric value.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV