Quick Navigation
BIN2DEC Function
Summary
The Excel BIN2DEC function converts a binary number to its decimal equivalent. It handles both positive and negative binary numbers using two's-complement notation for signed values.
Syntax
BIN2DEC(number)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| number | Binary String |
Yes | The binary number (up to 10 bits) where the first bit is the sign and the rest represent magnitude in two's-complement notation. |
Using the BIN2DEC Function
BIN2DEC is essential for converting binary representations - common in computing and digital electronics - into familiar decimal format for calculations and analysis in Excel spreadsheets.
Common BIN2DEC Examples
Positive Binary Conversion
=BIN2DEC("1100100")Converts binary 1100100 (positive) to decimal 100.
Negative Binary Conversion
=BIN2DEC("1111111111")Converts binary 1111111111 (negative in two's complement) to decimal -1.
Frequently Asked Questions
Common Errors and Solutions
#NUM!
Cause: Input exceeds 10 characters or contains invalid binary digits
Solution: Ensure input is 10-bit or shorter binary string (0s and 1s only)
#VALUE!
Cause: Non-text/number input
Solution: Provide binary number as text or number
Notes
- Maximum 10 bits (1 sign + 9 magnitude)
- Binary strings longer than 10 characters return #NUM!
- All 1s in 10 bits (1111111111) = -1 in decimal
- Positive numbers have 0 as MSB, negatives have 1
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2003 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+