BIN2DEC Function

You can convert binary number to a decimal number.
The binary number contains only 0 and 1 values.
Decimal pattern is 8 4 2 1.

It has a limit of 10 characters
If you write 10 times 1 it will return -1


Syntax

=BIN2DEC(number)

Arguments

Number: The binary number(reference) which you want to convert in to decimal.

Behavior

Here we have taken an example of binary numbers from"000" to "111" which gives result in decimal numbers

A limit of this function is 10 character. If you write 10 times "1" function will return "-1" as shown in above example

If you write more than 10 characters to function it will return #NUM error.

Usage

BIN2DEC Function is used to convert a binary number into a decimal number

Returns

If you give the binary number the function will return the decimal number