Spread.NET 18 Formula Reference
Formula Functions / Functions A to C / BIN2DEC
In This Topic
    BIN2DEC
    In This Topic

    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