How to Use DEC2BIN Function in Excel 365? – {With Examples}
Tags: dec2binfunctioninexc, excelfunctions
Published: 2020-08-14 11:25:49

---
title: How to Use DEC2BIN Function in Excel 365? – {With Examples}
published: true
date: 2020-08-14 06:22:43 UTC
tags: DEC2BINFunctioninExc,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-dec2bin-function-in-excel-365-with-examples/
---

## DEC2BIN Function in Excel:

In this article, we are going to see how to use **DEC2BIN function in Excel 365** with its syntax, explanation, and examples. Let’s get into this article!! Get 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:

- [**DEC2BIN- Function Definition**](#1)
- [**Syntax**](#2)
- [**Examples**](#3)
- [**Closure**](#4)

## DEC2BIN – Function Definition:

- This function will **convert the decimal number into binary values**.
- **DEC2BIN**  **function** is just opposite to [**BIN2DEC function**](https://geekexcel.com/how-to-use-bin2dec-function-in-excel-365-with-examples/).

## Syntax:

**=DEC2BIN(number, [places])**

### Argument Description:

**Number** – The decimal number that you want to convert to binary.

**Places** – It is optional. It is used for padding the output value with leading zeros. If you don’t mention the places, it returns the exact value of the input.

### **Note:**

- If the decimal number is less than -512 or greater than 511, it returns the **#NUM!** Error value.
- If you give 0 or any negative number in places option, it will show **#NUM!** Error.
- If the number (decimal) or places is non-numeric, it will return **#VALUE!** Error.

## Examples:

The following examples will show you clearly how **DEC2BIN** works.

### Example 1:

- Kindly, refer to the below screenshot.
- You can see the decimal input in the Cell **A3** and its places in Cell **B3, ** after applying the DEC2BIN function, it gives the result as binary value in the **active cell C3**.

![Decimal to Binary Conversion](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-19.png)<figcaption id="caption-attachment-11614">Decimal to Binary Conversion</figcaption>

### Example 2:

- If the decimal number is less than -512 or greater than 511, it returns the **#NUM!** Error value.
- If you give 0 or any negative number in places option, it will show **#NUM!** Error.

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

### Example 3:

- If the number (decimal) or places is non-numeric, it will return **#VALUE!** Error.

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

## Closure:

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

### Similar Functions:

- [**DEC2HEX Function**](https://geekexcel.com/how-to-use-dec2hex-function-in-ms-excel-365-with-examples/)
- [**DEC2OCT Function**](https://geekexcel.com/how-to-use-dec2oct-function-in-excel-365-with-examples/)

### Read Also:

- [How to Use “BITAND Function” in Excel 365? – { with Examples} ](https://geekexcel.com/how-to-use-bitand-function-in-excel-365-with-examples/)
- [How to Use BIN2HEX Function in Excel 365? {With example}](https://geekexcel.com/how-to-use-bin2hex-function-in-excel-365-with-example/)