BIN2DEC

Converts a binary number to decimal.

Sample Usage

BIN2DEC(101)
BIN2DEC(C5)

Syntax

BIN2DEC(number)

• number - The binary number to be converted.
  
  

Examples

BIN2DEC(101) returns a value of 5.
BIN2DEC(C5) converts the binary number contained in C5 to decimal.

Notes

• If number is negative, the value of places is ignored and DEC2DEC returns a 10-character decimal number . 
• number cannot contain more than 10 characters.
• If number is not a valid binary number, BIN2DEC returns the #NUM! error value.
• If places is not an integer, it is truncated.
• If places is non-numeric, BIN2DEC returns the #VALUE! error value.
• If places is negative, BIN2DEC returns the #NUM! error value.
• If the number of digits required is greater than the specified places, the #NUM! error is returned.