Use Of Dec2Bin
Decimal Number
|
Binary Equivalent
| ||
0
|
0
|
=DEC2BIN(C4)
| |
1
|
1
|
=DEC2BIN(C5)
| |
2
|
10
|
=DEC2BIN(C6)
| |
3
|
11
|
=DEC2BIN(C7)
| |
511
|
111111111
|
=DEC2BIN(C8)
| |
512
|
#NUM!
|
=DEC2BIN(C9)
| |
-1
|
1111111111
|
=DEC2BIN(C10)
| |
-2
|
1111111110
|
=DEC2BIN(C11)
| |
-3
|
1111111101
|
=DEC2BIN(C12)
| |
-511
|
1000000001
|
=DEC2BIN(C13)
| |
-512
|
1000000000
|
=DEC2BIN(C14)
| |
Decimal Number
|
Places To Pad
|
Binary Equivalent
| |
1
|
1
|
1
|
=DEC2BIN(C17,D17)
|
1
|
2
|
01
|
=DEC2BIN(C18,D18)
|
1
|
3
|
001
|
=DEC2BIN(C19,D19)
|
1
|
9
|
000000001
|
=DEC2BIN(C20,D20)
|
-1
|
1
|
1111111111
|
=DEC2BIN(C21,D21)
|
What Does It Do ?
This function converts a decimal number to its binary equivalent.
It can only cope with decimals ranging from -512 to 511.
The result can be padded with leading 0 zeros, although this is ignored for negatives.
Syntax
=DEC2BIN(DecimalNumber,PlacesToPad)
The PlacesToPad is optional.
Formatting
No special formatting is needed.
मेरी कहानियाँ Index प्रतिदिन सुविचार
Use Of Dec2Bin
Decimal Number
|
Binary Equivalent
| ||
0
|
0
|
=DEC2BIN(C4)
| |
1
|
1
|
=DEC2BIN(C5)
| |
2
|
10
|
=DEC2BIN(C6)
| |
3
|
11
|
=DEC2BIN(C7)
| |
511
|
111111111
|
=DEC2BIN(C8)
| |
512
|
#NUM!
|
=DEC2BIN(C9)
| |
-1
|
1111111111
|
=DEC2BIN(C10)
| |
-2
|
1111111110
|
=DEC2BIN(C11)
| |
-3
|
1111111101
|
=DEC2BIN(C12)
| |
-511
|
1000000001
|
=DEC2BIN(C13)
| |
-512
|
1000000000
|
=DEC2BIN(C14)
| |
Decimal Number
|
Places To Pad
|
Binary Equivalent
| |
1
|
1
|
1
|
=DEC2BIN(C17,D17)
|
1
|
2
|
01
|
=DEC2BIN(C18,D18)
|
1
|
3
|
001
|
=DEC2BIN(C19,D19)
|
1
|
9
|
000000001
|
=DEC2BIN(C20,D20)
|
-1
|
1
|
1111111111
|
=DEC2BIN(C21,D21)
|
What Does It Do ?
This function converts a decimal number to its binary equivalent.
It can only cope with decimals ranging from -512 to 511.
The result can be padded with leading 0 zeros, although this is ignored for negatives.
Syntax
=DEC2BIN(DecimalNumber,PlacesToPad)
The PlacesToPad is optional.
Formatting
No special formatting is needed.
मेरी कहानियाँ Index प्रतिदिन सुविचार
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें