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)
How to use BIN2DEC Function in Excel?

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.