DEC2BIN Function (Functions in Excel)
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. |
0 comments:
Post a Comment