ExcelFlux

BITOR function

a bitwise OR of 2 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

Combine enabled bits across two registers.

A worked example from the workbook

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

Expected result7

See the inputs and instructions for all 3 examples

Syntax

BITOR(number1, number2)

Copyable formulas

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

Expected result

7

Worked examples

Combine enabled bits across two registers.

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 =BITOR(A7,B7) 7
Record 2 =BITOR(A8,B8) 14
Record 3 =BITOR(A9,B9) 7
Microsoft Excel reference