|
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.