BINARY to DECIMAL Formula
This function
converts a binary number to decimal.Negative numbers are
represented using two's-complement notation.
Click image to enlarge.....
|
|
|
|
|
|
|
|
|
|
Binary Number
|
Decimal Equivalent
|
|
|
|
|
|
0
|
#REF!
|
=BIN2DEC(C4)
|
|
|
|
|
1
|
1
|
=BIN2DEC(C5)
|
|
|
|
|
10
|
2
|
=BIN2DEC(C6)
|
|
|
|
|
11
|
3
|
=BIN2DEC(C7)
|
|
|
|
|
111111111
|
511
|
=BIN2DEC(C8)
|
|
|
|
|
1111111111
|
-1
|
=BIN2DEC(C9)
|
|
|
|
|
1111111110
|
-2
|
=BIN2DEC(C10)
|
|
|
|
|
1111111101
|
-3
|
=BIN2DEC(C11)
|
|
|
|
|
1000000000
|
-512
|
=BIN2DEC(C12)
|
|
|
|
|
11111111111
|
#NUM!
|
=BIN2DEC(C13)
|
|
|
|
|
|
|
|
|
|
|
What Does It Do ?
|
|
|
|
|
|
|
This
function converts a binary number to decimal.
|
|
|||
|
|
Negative
numbers are represented using two's-complement notation.
|
||||
|
|
|
|
|
|
|
|
|
Syntax
|
|
|
|
|
|
|
=BIN2DEC(BinaryNumber)
|
|
|
||
|
|
The
binary number has a limit of ten characters.
|
|
|||
|
|
|
|
|
|
|
|
|
Formatting
|
|
|
|
|
|
|
No
special formatting is needed.
|
|
|
||