ReferenceFunctionsEngineering Functions

BITOR

BITOR: Returns the bitwise OR of two non-negative integers.

Summary

Combines matching bits from both inputs and keeps bits set in either number.

Remarks

Arguments are coerced to numbers and must be whole numbers in the range [0, 2^48).
Returns #NUM! for negative values, fractional values, or out-of-range values.
Propagates input errors.

Examples

Merge bit flags

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

15

Set an additional bit

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

9

FAQ

Does `BITOR` accept decimal-looking values like `3.0`?

Yes if they coerce to whole integers; non-integer values still return #NUM!.

Runtime metadata

Category

Engineering

Signature

BITOR(arg1: Number, arg2: Number)

Arity

min 2, max 2

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/engineering.rs

BITLSHIFT

BITLSHIFT: Shifts a non-negative integer left or right by a given bit count.

BITRSHIFT

BITRSHIFT: Shifts a non-negative integer right or left by a given bit count.

On this page

Summary Remarks Examples Related functions FAQ Does BITOR accept decimal-looking values like 3.0?Runtime metadata