Calc BIN2DEC function

For a full list of available calculation functions, please read What calculation functions are supported.

This article describes the formula syntax and usage of the BIN2DEC function.

Description

Converts a binary number to decimal.

Syntax

BIN2DEC(number)

• number - Required. The binary number you want to convert to decimal. The number can be a text string or a number.

Remarks

• If the number is not a valid binary number, BIN2DEC returns the #NUM! error value.
• If the number is larger than 511, BIN2DEC returns the #NUM! error value.
• If the number is less than -512, BIN2DEC returns the #NUM! error value.

Example

Errors

For a full list of formula errors, please read Formula errors.

Related functions

• Calc BIN2HEX function
• Calc BIN2OCT function
• Calc CONVERT function
• Calc DEC2BIN function
• Calc DEC2HEX function