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
- Click on an empty cell (like F5 ).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select Engineering category.
5. Select BIN2DEC function.
6. Then select ok.
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.
Examples of BIN2DEC function in Excel
Example 1:
How to use BIN2DEC function in excel
You can see examples of BIN2DEC function below:
bin2dec(A2) ----->>>>answer is 0
bin2dec(A3) ----->>>>answer is 1
bin2dec(A4) ----->>>>answer is 2
bin2dec(A5) ----->>>>answer is 3
bin2dec(A6) ----->>>>answer is 4Purpose 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)
