Excel BIN2DEC Function
How to use the BIN2DEC Function
This Excel tutorial explains how to use the Excel BIN2DEC function with syntax and examples.
SUMMARY:
The Excel BIN2DEC function converts a binary number to a decimal number. The input number must contain only zeros and ones and be less than 10 characters long, otherwise the function returns the #NUM! error value.
For example,
- The formula =BIN2DEC(101) would return 5
- The formula =BIN2DEC(10) would return 2
PURPOSE:
To converts a binary number to decimal.
RETURN VALUE:
The BIN2DEC function returns a Decimal Number.
SYNTAX:
=BIN2DEC(number)
ARGUMENTS:
The BIN2DEC function syntax has the following arguments:
- number: Required. The binary number you want to convert to a decimal.
- Number cannot contain more than 10 characters (10 bits).
- The most significant bit of number is the sign bit. The remaining 9 bits are magnitude bits.
REMARKS:
- Negative numbers are represented using two's-complement notation.
- If number is not a valid binary number, or if number contains more than 10 characters (10 bits), BIN2DEC returns the #NUM! error value.
Diffrent way to use the BIN2DEC function...
BIN2DEC Function Error:
If number is not a valid binary number, or if number contains more than 10 characters (10 bits).BIN2DEC function returns the #NUM! error
