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

## No comments:

## Post a Comment