ID EN
#Engineering

BIN2DEC

Excel Functions

Converts a binary number to decimal

Syntax

EXCEL
=BIN2DEC(number)

Arguments

Parameter Description
number The binary number you want to convert to decimal.

Return Value

Decimal Number

Details

The first bit of the binary number indicates whether the number is positive or negative. The other nine digits represent the size of the number, the max of which is 511 (2^9 - 1). A negative binary number is expected to use the two's complement notation.

See Also

DEC2BIN