BITLSHIFT
Returns a value number shifted left by shift_amount bits.
EngineeringEngineering & Science
What it does
Shifts the bits of a number to the left by a specified amount (equivalent to multiplying by 2^shift_amount).
Syntax
BITLSHIFT(number, shift_amount)
Arguments
number(number) — Integer to shift.shift_amount(number) — Number of bits to shift.
Examples
Bitwise Left Shift
Shift 4 (100) left by 2 bits.
FORMULA
=BITLSHIFT(4, 2)
RESULT
16
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Num | Shift |
| 2 | 4 | 2 |