Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

How to Use the BITAND Function in Excel

The BITAND function applies the AND operation on two decimal number. In the AND operation, the bitwise and is applied. This step by step tutorial will assist all levels of Excel users in understanding the binary conversion and the BITAND function.

Figure 1. The result of the function

Conversion of the decimal to binary

Having in mind that the BITAND function operates with the binary numbers, we will briefly explain how to convert decimal to binary.

Figure 2. Conversion of decimal numbers to binary

In Figure 2, we can see that the binary value of 140 is 10001100. The function for the conversion is DEC2BIN. The function takes only one parameter, a decimal number, and return a number in a binary format.

Syntax of the BITAND Formula

The generic formula for the BITAND function is:

=BITAND(number1, number2)

The parameters of the BITAND function are:

  • Number1 and number2 – decimal numbers that we want to apply bitwise and.

Setting up Our Data for the BITAND Function

Figure 3. Data that we will use in the BITAND example

Let’s look at the structure of the data we will use. In the cells B3 and B4 we have the input number. We want to get the result of the BITAND function in the cell F2. The binary values in C3 and C4 are here to help us to understand the function.

Performing bitwise AND on two numbers

In our example, we want to apply bitwise AND on 140 and 182. The binary formats of these numbers are 10001100 and 10110110.

Figure 4. Using the BITAND function

The formula looks like:

=BITAND(B3, B4)

The parameter number1 is the cell B3, while the parameter number2 is the cell B4. The function applies AND on numbers’ digits (1 and 1 is 1, 0 and 0 is 0, 0 and 1 is 0, etc.). The result of this operation is 10000100, which is 132 in decimal format. This is the result of the function in the cell F2.

To apply the BITAND function, we need to follow these steps:

  • Select cell F2 and click on it
  • Insert the formula: =BITAND(B3, B4)
  • Press enter

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Solution examples
wondering if there is a formula that when the name in one cell changes, the formula in the other cell changes? for example: working on a calculating cost for harvesting grain crops based on acres, bushels harvested, and bushels harvested over x/bushels per acre. in cell B3 i want when cell A1 says "wheat harvest" it will subtract 20 from cell B2, but when cell A1 says "corn harvest" i want to subtract 40 from cell B2 is this possible? thanks
Solved by T. D. in 20 mins
Help, I need a formula to measure if date entered in column e, is between date in column a and date in column b. please
Solved by V. U. in 20 mins
Adding criteria to If(And( ),Sumproducts()
Solved by G. U. in 19 mins
I need section of text deleted in a column . Problem is the cell in each column Is html and seems it will be a challenge but if you can do this , you are genius
Solved by B. A. in 60 mins
How do I prevent Duplicate entries in multiple columns in Excel using data validation in MSExcel 2016. I would like to prevent the user from data entering a code more than once in three column ranges
Solved by B. D. in 60 mins

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

Did this post not answer your question?
Get a solution from connecting with the expert

Another blog reader asked this question today on Excelchat:

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc