How to use the BIN2DEC function
Author: Oscar Cronquist Article last updated on May 11, 2022
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, […]
Functions in 'Engineering' category
The BIN2DEC function function is one of many functions in the 'Engineering' category.
Converts a binary number to the decimal number system.
Converts a binary number to hexadecimal.
Converts a binary number to octal.
Calculates a bitwise 'AND' of two numbers.
Calculates a number whose binary representation is shifted left by a specified number of bits.
Performs a bitwise 'OR' of two numbers.
Calculates the number where the binary equivalent is shifted right by a specified number of bits and then converted back to a number.
Calculates a decimal number that is a result of a bitwise comparison "XOR" of two numbers.
Returns a complex number based on a real and imaginary number.
Converts a number from one measurement system to another.
Converts a decimal number to a binary number.
Converts a decimal number to a hexadecimal number.
Converts a decimal number to an octal number.
Evaluates whether two numerical values are equal.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form