Converts the specified binary (base 2) number to its decimal equivalent.
Syntax
 Copy Code
|
|---|
BIN2DEC( NumberOrText x ) → Number |
Parameters
- x
- Required. The binary number to convert, expressed as either text or number. This value should not contain more than 10 characters.
Remarks
If x is not a valid binary number, the function returns the #VALUE! error value. If x contains more than 10 characters (10 bits), the function returns the #NUM! error value.
Example
| Formula
Copy Code
|
|---|
=BIN2DEC(100100) |
See Also
Function Reference
BIN2HEX Function
BIN2OCT Function
DEC2BIN Function
HEX2BIN Function
OCT2BIN Function