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

- Click on
**an empty cell**(like F5).

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

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

4. Select **ENGINEERING **category.

5. Select **BITLSHIFT** function.

6. Then select **ok**.

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:

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

**BITLSHIFT**

It Returns a number **shifted left by shift** amount bits.

## Return value of **BITLSHIFT** function

**BITLSHIFT**

It returns a number.

## Arguments of **BITLSHIFT** function

**BITLSHIFT**

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

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

## Errors in **BITLSHIFT** function

**BITLSHIFT**