Version Availability:

Desktop version starting Excel 2013

Function Type: Engineering


Returns a value number shifted left by shift_amount bits.

Function Structure:

=BITLSHIFT(number, shift_amount).

Argument Breakdown:

number – The number to be bit shifted.

shift_amount – The amount of bits to shift, if negative shifts bits to the right instead.


Error will occur if the value of If the value of Number is greater than (2^48)-1 and the value of Shift_amount is greater than 53.

If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig.

Back to Learn Excel->

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: