## How to use the BITLSHIFT function

*Article last updated on March 28, 2018*

The BITLSHIFT function calculates a number whose binary representation is shifted left by a specified number of bits.

Formula in cell D3:

Number 5 is 101 binary. Adding one zero from the right you get 1010 binary which is number 10.

### Excel Function Syntax

BITLSHIFT(*number*, *shift_amount*)

### Arguments

number |
Required. The number you want to shift. |

shift_amount |
Required. How many zeros you want to add from the right. |

### Comments

Maximum number is 2^48 = 2.81475E+14.

### Functions in 'Engineering'

The BITLSHIFT function function is one of many functions in the 'Engineering' category.

How to use the BIN2DEC function

The BIN2DEC function converts a binary number to decimal. Formula in cell B3: =BIN2DEC(11001) Excel Function Syntax BIN2DEC(number) Arguments number […]

How to use the BIN2HEX function

The BIN2HEX function converts a binary number to hexadecimal. Formula in cell B3: =BIN2HEX(11001) Excel Function Syntax BIN2HEX(number,[places]) Arguments number […]

How to use the BIN2OCT function

The BIN2OCT function converts a binary number to octal. Formula in cell B3: =BIN2OCT(11001) Excel Function Syntax BIN2OCT(number,[places]) Arguments number […]

How to use the BITAND function

The BITAND function calculates a bitwise 'AND' of two numbers. The function performs AND logic bit by bit on the numbers […]

How to use the BITLSHIFT function

The BITLSHIFT function calculates a number whose binary representation is shifted left by a specified number of bits. Formula in […]

The BITOR function performs a bitwise 'OR' of two numbers. Bitwise meaning each digit in the binary equivalent. Formula in […]

How to use the BITRSHIFT function

The BITRSHIFT function calculates the number where the binary equivalent is shifted right by a specified number of bits and […]

How to use the BITXOR function

The BITXOR function calculates a decimal number that is a result of a bitwise comparison "XOR" of two numbers. XOR […]

How to use the COMPLEX function

The COMPLEX function returns a complex number based on a real and imaginary number. Formula in cell B3: =COMPLEX(2,3) Excel […]

How to use the CONVERT function

The CONVERT function converts a number from one measurement system to another. Formula in cell E3: =CONVERT(B3, C3, D3) The […]

How to use the DEC2BIN function

The DEC2BIN function converts a decimal number to a binary number. Formula in cell D3: =DEC2BIN(B3,C3) Excel Function Syntax DEC2BIN(number, […]

How to use the DEC2HEX function

The DEC2HEX function converts a decimal number to a hexadecimal number. Formula in cell D3: =DEC2HEX(B3,C3) Excel Function Syntax DEC2HEX(number, […]

How to use the DEC2OCT function

The DEC2OCT function converts a decimal number to an octal number. Formula in cell D3: =DEC2OCT(B3,C3) Excel Function Syntax DEC2OCT(number, […]

## How to comment

How to add a formula to your comment<code>Insert your formula here.</code>

Convert less than and larger than signsUse html character entities instead of less than and larger than signs.

< becomes < and > becomes >

How to add VBA code to your comment[vb 1="vbnet" language=","]

Put your VBA code here.

[/vb]

How to add a picture to your comment:Upload picture to postimage.org or imgur

Use the img tag, like this: <img src="Insert pic link here">

Contact OscarYou can contact me through this contact form