Excel BITLSHIFT Function

What is BITLSHIFT function in Excel?


The BITLSHIFT function is one of the Engineering functions of Excel.

It Returns a number shifted left by shift amount bits.

We can find this function in Engineering category of the insert function Tab.

How to use BITLSHIFT function in excel

  1. Click on an empty cell (like F5).
an empty cell in excel

2. Click on the fx icon (or press shift+F3).

 fx icon in excel

3. In the insert function tab you will see all functions.

insert function tab in excel

4. Select ENGINEERING category.

5. Select BITLSHIFT function.

6. Then select ok.

excel BITLSHIFT function

7. In the function arguments Tab you will see BITLSHIFT function.

8. Number is the decimal representation of the binary number you want to evaluate.

9. Shift_amount is the number of bits that you want to shift Number left by.

10. You will see the results in the formula result section.

Examples of BITLSHIFT function in Excel

Example 1:

How to use BITLSHIFT function in excel

You can see examples of BITLSHIFT function below:

Examples of BITLSHIFT function in Excel
bitlshift(A2,B2) ----->>>>answer is  2222

bitlshift(A3,B3) ----->>>>answer is  4444

bitlshift(A4,B4) ----->>>>answer is  8888

bitlshift(A5,B5) ----->>>>answer is  17776

bitlshift(A6,B6) ----->>>>answer is  1111

Purpose of BITLSHIFT function

It Returns a number shifted left by shift amount bits.

Return value of BITLSHIFT function

It returns a number.

Arguments of BITLSHIFT function

This function has just 2 Argument.

The argument of BITLSHIFT function is number.

Number is the decimal representation of the binary number you want to evaluate.

Shift_amount is the number of bits that you want to shift Number left by.

The argument of BITLSHIFT function is required and not optional.

BITLSHIFT(number) = number

Version of excel supports BITLSHIFT function

This function is available for all excel versions (2003-2019)

Errors in BITLSHIFT function

BITLSHIFT related functions 

Leave a Reply

Your email address will not be published. Required fields are marked *