## 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 cell D3:

=BITLSHIFT(B3, C3)

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' category

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

Converts a binary number to the decimal number system.

Converts a binary number to hexadecimal.

Converts a binary number to octal.

Calculates a bitwise 'AND' of two numbers.

Calculates a number whose binary representation is shifted left by a specified number of bits.

Performs a bitwise 'OR' of two numbers.

Calculates the number where the binary equivalent is shifted right by a specified number of bits and then converted back to a number.

Calculates a decimal number that is a result of a bitwise comparison "XOR" of two numbers.

Returns a complex number based on a real and imaginary number.

Converts a number from one measurement system to another.

Converts a decimal number to a binary number.

Converts a decimal number to a hexadecimal number.

Converts a decimal number to an octal number.

Evaluates whether two numerical values are equal.

## 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

Paste image link to your comment.

Contact OscarYou can contact me through this contact form