ExcelFlux

BITAND function

a 'Bitwise And' of two numbers.

Engineering · Excel 2013+

Where can you use it?

Engineering and technical analysis teams. If the calculation needs a number base, unit, complex number or special mathematical operation, check the input format against the example.

Scenario in the workbook

Extract bits enabled in both device flags.

A worked example from the workbook

RowAB
6First valueSecond value
763
81210
974
Record 1
=BITAND(A7,B7)

Expected result2

See the inputs and instructions for all 3 examples

Syntax

BITAND( number1, number2)

Copyable formulas

English Excel · en-US
=BITAND(6,3)
Turkish Excel · tr-TR
=BİTVE(6;3)

Expected result

2

Worked examples

Extract bits enabled in both device flags.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 First value Second value
7 6 3
8 12 10
9 7 4
Case Formula Expected result
Record 1 =BITAND(A7,B7) 2
Record 2 =BITAND(A8,B8) 8
Record 3 =BITAND(A9,B9) 4
Microsoft Excel reference