Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelBIN2DEC Function in Excel

# BIN2DEC Function in Excel

In this post, you will learn about the BIN2DEC function in Excel, its usage, syntax, and how to use it in your excel spreadsheet.

## BIN2DEC Function in Excel

The BIN2DEC function in Excel Converts a binary number (BIN) to decimal (DEC). This function is a built-in function in Excel (Available on Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007) that has been categorized as anÂ Engineering Function. It can also be used as a worksheet function and can be entered as a formula in a cell of a worksheet.

#### Syntax

`= BIN2DEC(number)`

Arguments:

• NumberÂ Â Â

The binary number you want to convert to decimal number. It is restricted to contain only 10 characters (10 bits).

## How to use the BIN2DEC in excel worksheet?

Using this function in a worksheet is simple, all you need to do is enter the function as a formula of the cell in the formula bar.

Take a look at the given example

Binary numbers:

• 10100010
• 100101
• 1000100
• 101010
• 100101001

The above numbers are the binary version of some decimal numbers. To find out the decimal numbers, Enter the given binary numbers in column A and in Column B, enter the following formula

`Formula: =BIN2DEC(A1)`

Here, A1 refers to the cell name or the cell address. Repeat the same to the other cells and you will get the decimal value of the binary values.

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021