-
Microsoft Excel Office 365
Learn How to Use Microsoft Excel BITAND Function
In this article, you will learn how to use the Microsoft Excel BITAND function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel BITAND function return value and syntax with the help of some examples.
Microsoft Excel BITAND Function
The main function of Microsoft Excel BITAND function is used to return the "Bitwise And" of two numbers. That implies with the help of BITAND function; you can able to return the decimal number representing the bitwise AND of two numbers.
Return Value of BITAND Function
The return value will be the decimal number.
Syntax of BITAND Function
=BITAND(number1, number2)
Where the argument:
number1: This is the positive decimal number.
number2: This is the positive decimal number.
How to Use Microsoft Excel BITAND Function?
The input number can be greater than or equal to zero and no longer than 2^48 - 1). The BITAND function performs logical AND operation on each corresponding bit in the binary representation of the two numbers.
Check out the list of all other articles:
- Learn How to Get nth Match in Microsoft Excel
- Learn How to Find Missing Values in Microsoft Excel
- Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
- Learn How to Sort by Text Length in Microsoft Excel
- Learn How to Sort by Two Columns in Microsoft Excel
- Learn How to Sort by Random in Microsoft Excel
- Learn How to Sort by One Column in Microsoft Excel
- Learn How to Sort by Custom List in Microsoft Excel
×
![]()
Paayi.com
Comments