Excel BIN2DEC Function: Convert Binary Numbers to Decimal

The BIN2DEC function in Excel converts a binary number (base-2) into a decimal number (base-10). This function is useful for students, engineers, programmers, and anyone working with binary data or computer systems.

What Does the BIN2DEC Function Do?

The BIN2DEC function takes a binary number containing only 0s and 1s and converts it into its decimal equivalent.

For example:

• Binary 1010 becomes decimal 10
• Binary 1111 becomes decimal 15

This function belongs to Excel’s Engineering Functions category.

Syntax of the BIN2DEC Function

=BIN2DEC(number)

Arguments:

• number – The binary number you want to convert to decimal.

Note: The binary number can contain up to 10 binary digits.

Example: Basic Usage

If cell A1 contains:

1010

Using the formula:

=BIN2DEC(A1)

Returns:

10

Because binary 1010 equals decimal 10.

More BIN2DEC Examples

Binary Number	Formula	Result
101	=BIN2DEC("101")	5
1111	=BIN2DEC("1111")	15
100000	=BIN2DEC("100000")	32
1100100	=BIN2DEC("1100100")	100

Working with Negative Binary Numbers

Excel supports signed binary numbers using the two’s complement system.

Example:

=BIN2DEC("1111111111")

Returns:

-1

This happens because Excel interprets 10-digit binary numbers beginning with 1 as negative numbers.

Common BIN2DEC Errors

#NUM! Error

You may see a #NUM! error if:

• The binary number contains digits other than 0 or 1
• The binary number exceeds 10 characters

Example:

=BIN2DEC("1021")

Returns:

#NUM!

Using BIN2DEC with Other Functions

Example: Convert Binary Text Stored in a Cell

=BIN2DEC(TRIM(A1))

This removes extra spaces before conversion.

Difference Between BIN2DEC and DEC2BIN

Function	Purpose
BIN2DEC	Converts binary to decimal
DEC2BIN	Converts decimal to binary

These functions are often used together in engineering and computer science calculations.

Important Notes

• BIN2DEC accepts a maximum of 10 binary digits
• Only binary digits (0 and 1) are allowed
• Negative numbers use two’s complement notation
• The function belongs to Excel’s Engineering Functions group

Conclusion

The Excel BIN2DEC function makes it easy to convert binary numbers into decimal values directly inside Excel. Whether you're learning computer science, working with digital systems, or analyzing binary data, BIN2DEC provides a quick and reliable solution.

Combine BIN2DEC with functions like DEC2BIN, HEX2DEC, and OCT2DEC for advanced number system conversions in Excel.

SEO Meta Description

<meta name="description" content="Learn how to use the Excel BIN2DEC function to convert binary numbers into decimal values. Includes syntax, examples, errors, and practical uses with free Excel examples." />

SEO Tags

Excel BIN2DEC function, binary to decimal Excel, Excel engineering functions, Excel binary conversion, BIN2DEC examples, Excel formulas, Excel computer science functions, Excel number conversion

Download Excel BIN2DEC Demo File