Formulas > =BITAND()

How to Use BITAND() in Google Sheets

Description

Bitwise boolean AND of two numbers..

How To Actually Use BITAND() in Sheets

BITAND(value1, value2)

Try BITAND yourself

In cells A1 and A2, enter two integers. Use the BITAND formula in cell B1 to calculate the bitwise AND of these two integers.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for BITAND(). Click through to watch.

Watch more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Embed a Number in a Website from a Google Sheet

Ever wanted to display some data from a google sheet on your site? Witho...

Advanced

How to Use AND() and OR() in IF() in Google Sheets For Multiple Criteria

One of the most simplest and useful formula combinations is using and an...

Beginner

AND() IF() OR()

How to Use AND() and OR() in IF() in Google Sheets For Multiple Criteria

One of the most simplest and useful formula combinations is using and an...

Beginner

AND() IF() OR()

Unlock these tutorials

Learn more about the BITAND() formula:

Generate a BITAND() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses BITAND(). 2 free AI generations, no signup. Members get unlimited use.

Generate a BITAND() formula

How to Use BITAND() in Google Sheets

Try BITAND yourself

More related tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Embed a Number in a Website from a Google Sheet

How to Use AND() and OR() in IF() in Google Sheets For Multiple Criteria

How to Use AND() and OR() in IF() in Google Sheets For Multiple Criteria