BIN2DEC function

The BIN2DEC function in Excel converts a binary number (base 2) to its decimal equivalent (base 10). This function is useful for converting binary data into a format that is easier to work with in mathematical and computational tasks.

Syntax

BIN2DEC(binary_number)

Parameters

• binary_number: This is a required parameter. It represents the binary number you want to convert to decimal. It must be a string (text value) representing a binary number, and it should only contain the digits 0 and 1.

How It Works

The BIN2DEC function takes the binary number as input and converts it into a decimal (base 10) number. It works by using the positional value of each binary digit (0 or 1) and multiplying it by 2 raised to the power of the position index (from right to left), summing the results to get the decimal equivalent.

For example, the binary number 1011 is equal to:

$$1 \times 2^3 + 0 \times 2^2 + 1 \times 2^1 + 1 \times 2^0 = 8 + 0 + 2 + 1 = 11$$

So, BIN2DEC("1011") will return 11.

Examples

1. Convert a Simple Binary Number to Decimal: If you want to convert the binary number 1101 to decimal:

   =BIN2DEC("1101")
   

   This will return 13, as the binary number 1101 is equal to the decimal number 13.

2. Convert a Negative Binary Number to Decimal: The BIN2DEC function also handles negative binary numbers in two’s complement notation. For example, if you have the binary number 11111111111111111111111111111010, it is a 32-bit representation of -6 in two’s complement:

   =BIN2DEC("11111111111111111111111111111010")
   

   This will return -6.

3. Convert Binary Number with Leading Zeros: Leading zeros in binary numbers do not affect the decimal result. For example, 00001010 is equivalent to 10:

   =BIN2DEC("00001010")
   

   This will return 10.

Important Notes

• Binary Format: The binary_number argument must be a text string containing only 0s and 1s. Excel will return an error if the string contains any non-binary characters (e.g., 2, 3, etc.).
• Negative Binary Numbers: If the binary number is a negative value in two’s complement format, BIN2DEC correctly interprets it and returns the negative decimal result. For example, BIN2DEC("11111111") (8-bit representation of -1) will return -1.
• Binary Length Limit: The maximum binary number that can be converted using BIN2DEC is 512 bits (for most systems), so be mindful of the input’s length when using this function.

Summary

The BIN2DEC function in Excel is used to convert a binary number to its decimal equivalent. It takes a binary string as input and calculates the decimal value by interpreting each binary digit’s position and value. This function can also handle negative binary numbers in two’s complement representation, making it useful for various applications in computing, electronics, and mathematical conversions.