Spread Formula Reference
BIN2DEC
Formula Functions > Functions A to C > BIN2DEC

This function converts a binary number to a decimal number.

Syntax

BIN2DEC(number)

Arguments

For the argument of this function, specify the binary numeric value to convert.

Remarks

An error value is returned if the number contains more than 10 digits or is invalid.

Data Types

Accepts numeric data. Returns numeric data.

Examples

BIN2DEC(1111111)

Version Available

This function is available in product version 2.0 or later.

See Also

BIN2HEX | BIN2OCT | DEC2BIN | OCT2DEC | Engineering Functions