How to Use “BITLSHIFT” Function in Excel 365? – {With Examples}
Tags: bitlshiftfunctionine, excelfunctions
Published: 2020-08-14 11:25:16

---
title: How to Use “BITLSHIFT” Function in Excel 365? – {With Examples}
published: true
date: 2020-08-13 06:35:34 UTC
tags: BITLSHIFTFunctioninE,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-bitlshift-function-in-excel-365-with-examples/
---

## BITLSHIFT Function in Excel:

In this article, we are going to see how to use **BITLSHIFT Function in Excel 365** with its syntax, explanation, and examples. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## Jump To:

- [**BITLSHIFT – Function Description**](#1)
- [**Syntax**](#2)
- [**Examples**](#3)
- [**Verdict**](#4)

## BITLSHIFT – Function Description:

- This function will shift the number (binary value) by the specified number of bits you want to shift.
- You can assign a shift\_amount either a positive number or negative number.

## Syntax:

**=BITLSHIFT(number, shift\_amount)**

### Argument Explanation:

**Number** – The input number to be shifted. It should be greater than or equal to 0.

**Shift\_amount** – Give amount of bits to be shifted. It should be an integer value.

### **Note:**

- If the value of shift\_amount is greater than 53, it returns **#NUM!** Error value.
- If you give any of the arguments as non-numeric value, it returns **#VALUE!** Error.
- You can assign a negative value to shift\_amount argument but it will shift the bits to the right.
- You can assign a positive number to the shift\_amount,  it will shift bits to the left.

## Examples:

Let’s see some examples to know how this function works.

### Example 1:

- In the below image, we have clearly shown how BITLSHIFT works and gives the result.
- You can see the input decimal value in the cell **A2** and its corresponding binary value in cell **B2**.
- We have given the shift\_amount as **2** ( **positive**  **number** ), so that it will shift bits to the left by 2.
- Kindly, refer to the shifted\_bits in the cell **E2**.
- You can see the result in the active cell **D2** and its formula in the **Formula**  **bar**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/Example.png)<figcaption id="caption-attachment-11595">Example</figcaption>

### Example 2:

- If the value of shift\_amount is greater than 53, it returns **#NUM!** Error value.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/Example-2.png)<figcaption id="caption-attachment-11596">Example 2</figcaption>

### Example 3:

- If you give any of the arguments as non-numeric value, it returns **#VALUE!** Error.

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/Example-3.png)<figcaption id="caption-attachment-11597">Example 3</figcaption>

## Verdict:

In this article, you can understand how to use **BITLSHIFT**  **Function in Excel** 365 with its syntax, description, and examples. Drop your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Read Also:

- [How to Use BIN2DEC Function in Excel 365? (With Examples)](https://geekexcel.com/how-to-use-bin2dec-function-in-excel-365-with-examples/)
- [Use ISTEXT Function in Microsoft Excel 365 In Easy Ways!!](https://geekexcel.com/use-istext-function-in-microsoft-excel-365-in-easy-ways/)
- [How to Use “BITAND Function” in Excel 365? – { with Examples }](https://geekexcel.com/how-to-use-bitand-function-in-excel-365-with-examples/)