BIN2DEC

Converts the specified binary (base 2) number to its decimal equivalent.

Syntax

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

=BIN2DEC(100100)
=BIN2DEC("1101001")

See Also

Function Reference
BIN2HEX Function
BIN2OCT Function
DEC2BIN Function
HEX2BIN Function
OCT2BIN Function