Menu
EXCEL BITLSHIFT FUNCTION
Excel BITLSHIFT Function Introduction
The BitLShift function in Excel produces an integer that has been shifted left by a given amount of bits.
Description of Excel BITLSHIFT Function
Syntax:
=BITLSHIFT( number, shift_amount )
Parameter:
The following arguments are provided:
Number:
- The number on which you wish the operation to be performed (must be a positive integer).
Shift_Amount:
- An integer value indicating how many bits the provided number should be shifted by.
Step By Step Guide of BITLSHIFT Function
Example:
The binary form of 5 is 101, and 101 moved to the left by two positions equals 10100.
This value is returned as the integer 20 in decimal form.
Key Points
- #NUM! – Occurs if one of the following conditions is met: the provided number argument is not an integer;
The number argument given is negative or larger than (248)-1.
The function’s output is larger than 248. - #VALUE! – This error occurs if one or both of the supplied arguments is not a number.
Related Functions
INDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowHLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
