Excel like a finance pro.
← The libraryPractice · 2 questions →
Engineering function
BITOR
Returns the bitwise OR of two numbers.
Rarely usedDifficulty 1350 · AdvancedUsage rank #422 of 520
When to use it
Bitwise OR: a bit is set where either input has it. Combining flags.
The shape of it
- Syntax
=BITOR(number1, number2)
Worked examples
Simple
=BITOR(23,10) → 31
10111 OR 01010 is 11111.
Combine flags
=BITOR(1,4) → 5
Setting two flags.
Set a flag
=BITOR(A2,8) → 14
Turn on bit 4 in A2 = 6.
Worth knowing
- Add a flag with BITOR rather than +, which double-counts if already set.
- Inputs below 2^48.
- BITAND tests, BITOR sets, BITXOR toggles.
Where it goes wrong
- #NUM! for negatives or non-integers.
- #VALUE! for text.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.