Excel BIN2DEC function

What is BIN2DEC function in Excel?


The BIN2DEC function is one of the Engineering functions of Excel.

It Converts a binary number to a decimal.

We can find this function in the Engineering category of insert function Tab.

How to use BIN2DEC function in excel

  1. Click on an empty cell (like F5 ).
an empty cell in excel

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

fx icon in excel

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

insert function tab in excel

4. Select Engineering category.

5. Select BIN2DEC function.

6. Then select ok.

excel BIN2DEC function

7. In the function arguments Tab you will see BIN2DEC function.

8. Number section is the binary number you want to convert.

9. You will see the results in the formula result section.

How to use BIN2DEC function in excel

Examples of BIN2DEC function in Excel

Example 1:

How to use BIN2DEC function in excel

You can see examples of BIN2DEC function below:

Examples of BIN2DEC function in Excel
bin2dec(A2) ----->>>>answer is  0

bin2dec(A3) ----->>>>answer is  1

bin2dec(A4) ----->>>>answer is  2

bin2dec(A5) ----->>>>answer is  3

bin2dec(A6) ----->>>>answer is  4

Purpose of BIN2DEC function

It Converts a binary number to a decimal.

Return value of BIN2DEC function

It returns a number.

Arguments of BIN2DEC function

This function has just 1 Argument.

The argument of BIN2DEC function is number.

Number section is the binary number you want to convert.

The argument of BIN2DEC function is required and not optional.

BIN2DEC(number) = number

Version of excel supports BIN2DEC function

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

Errors in BIN2DEC function

BIN2DEC related functions 

Leave a Reply

Your email address will not be published. Required fields are marked *