Excel functions / Math

BIN2DEC function

Turns a binary number into an ordinary one.

Syntax

=BIN2DEC(number)

Arguments

When to use it

BIN2DEC reads a binary number (up to 10 digits of 0s and 1s) and gives it as an ordinary number.

Examples

  1. Binary 1010

    ABC
    1Binary
    2'101010

    In C2: =BIN2DEC(A2) → 10

    Try this example

  2. Eight bits all set

    ABC
    1Binary
    2'11111111255

    In C2: =BIN2DEC(A2) → 255

    Try this example

Common mistakes

BIN2DEC in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try BIN2DEC in the playground

Related functions