Formulas and Functions
BITLSHIFT
The BITLSHIFT function returns the bitwise LSHIFT of two numbers.
BITLSHIFT(value, shift-amount)
value: The number to shift. value must be non-negative.
shift-amount: The number of places to the left to shift value.
Examples |
|---|
=BITLSHIFT(12,3) returns 96. The binary equivalent of 12 is 1100, and adding three 0s is 1100000. 1100000 in decimal form is 96. |