How to use the BIN2DEC function
Article updated on March 28, 2018
The BIN2DEC function converts a binary number to decimal.
Formula in cell B3:
=BIN2DEC(11001)
Excel Function Syntax
BIN2DEC(number)
Arguments
| number | Required. The binary number you want to convert. |
Comments
Maximum binary values are 10 characters.
Number cannot contain more than 10 characters (10 bits).
To convert a decimal value to binary use the DEC2BIN function.
How to use the DEC2BIN function
The DEC2BIN function converts a decimal number to a binary number. Formula in cell D3: =DEC2BIN(B3,C3) Excel Function Syntax DEC2BIN(number, […]
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas.
Click on headers to sort table.
Functions in 'Engineering'
The BIN2DEC function function is one of many functions in the 'Engineering' category.
The BIN2DEC function converts a binary number to decimal. Formula in cell B3: =BIN2DEC(11001) Excel Function Syntax BIN2DEC(number) Arguments number […]
The BIN2HEX function converts a binary number to hexadecimal. Formula in cell B3: =BIN2HEX(11001) Excel Function Syntax BIN2HEX(number,[places]) Arguments number […]
The BIN2OCT function converts a binary number to octal. Formula in cell B3: =BIN2OCT(11001) Excel Function Syntax BIN2OCT(number,[places]) Arguments number […]
The BITAND function calculates a bitwise 'AND' of two numbers. The function performs AND logic bit by bit on the numbers […]
The BITLSHIFT function calculates a number whose binary representation is shifted left by a specified number of bits. Formula in […]
The BITOR function performs a bitwise 'OR' of two numbers. Bitwise meaning each digit in the binary equivalent. Formula in […]
The BITRSHIFT function calculates the number where the binary equivalent is shifted right by a specified number of bits and […]
The BITXOR function calculates a decimal number that is a result of a bitwise comparison "XOR" of two numbers. XOR […]
The COMPLEX function returns a complex number based on a real and imaginary number. Formula in cell B3: =COMPLEX(2,3) Excel […]
The CONVERT function converts a number from one measurement system to another. Formula in cell E3: =CONVERT(B3, C3, D3) The […]
The DEC2BIN function converts a decimal number to a binary number. Formula in cell D3: =DEC2BIN(B3,C3) Excel Function Syntax DEC2BIN(number, […]
The DEC2HEX function converts a decimal number to a hexadecimal number. Formula in cell D3: =DEC2HEX(B3,C3) Excel Function Syntax DEC2HEX(number, […]
The DEC2OCT function converts a decimal number to an octal number. Formula in cell D3: =DEC2OCT(B3,C3) Excel Function Syntax DEC2OCT(number, […]
