Change Binary to Decimal
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
| ||||||||
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें