Wednesday, September 16, 2015

Excel Function: BIN2DEC Function

Use of BIN2DEC Function

BIN2DEC Function returns a decimal number from a binary number.

Way to express

BIN2DEC(number)
Mathematical Example:

Binary
0
1
10
11
100
101
110
111
1000
1001
1010
Decimal
0
1
2
3
4
5
6
7
8
9
10

BIN2DEC Function example


When it returns error


If the number is not binary (1, 0) then it returns error