BIN2DEC Function (Functions in Excel)
Binary Number | Decimal Equivalent | |
0 | 0 | =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. |
0 comments:
Post a Comment