BIN2DEC Function

Summary

BIN2DEC converts a binary number (base-2 text or digits) into its decimal integer equivalent (base-10). If you have binary bit strings or sensor status words and need a normal numeric value in your calculations, this is the function to use.

This is especially helpful when dealing with binary registers, hardware telemetry, network subnetting, or digital flags. BIN2DEC bridges the gap between binary representations and standard Excel mathematical operations.

Syntax

=BIN2DEC(number)

number is the binary number you want to convert. It can be supplied as a text string or as numeric digits containing only 0 and 1.

Arguments

• number - [required] The binary number you want to convert. It cannot contain more than 10 binary characters (10 bits). The most significant bit is the sign bit; the remaining 9 bits are magnitude bits. Negative numbers are represented using two's-complement notation.

Key Rules and Limitations

• Input characters: Only 0 and 1 are permitted. Any other character results in a #NUM! error.
• Bit limit: The input cannot exceed 10 characters (bits). Larger bitstrings return #NUM!.
• Supported Range: Converted decimal outputs range from -512 (binary 1000000000) to 511 (binary 0111111111).

Common Examples