Number System Function in Excel
Number System Function
Binary to Decimal
=BIN2DEC(A2)
|
A |
B |
1 |
Binary |
Decimal |
2 |
100110 |
38 |
3 |
11011 |
33 |
4 |
1001 |
11 |
5 |
10001 |
21 |
6 |
1101 |
15 |
7 |
11011 |
33 |
8 |
101010 |
52 |
Binary to Octal
=BIN2OCT(A2)
|
A |
B |
1 |
Binary |
Octal |
2 |
100110 |
46 |
3 |
11011 |
33 |
4 |
1001 |
11 |
5 |
10001 |
21 |
6 |
1101 |
15 |
7 |
11011 |
33 |
8 |
101010 |
52 |
Binary to Hexadecimal
=BIN2HEX(A2)
|
A |
B |
1 |
Binary |
Hexadecimal |
2 |
101111 |
2F |
3 |
101010 |
18A92 |
4 |
111111 |
1B207 |
5 |
101011 |
18A93 |
6 |
111101 |
1B1FD |
7 |
101110 |
18AF6 |
8 |
100001 |
186A1 |
Decimal to Binary
=DEC2BIN(A2)
|
A |
B |
1 |
Decimal |
Binary |
2 |
56 |
111000 |
3 |
74 |
1001010 |
4 |
52 |
110100 |
5 |
63 |
111111 |
6 |
74 |
1001010 |
7 |
52 |
110100 |
8 |
63 |
111111 |
Decimal to Octal
=DEC2OCT(A2)
|
A |
B |
1 |
Decimal |
Octal |
2 |
56 |
70 |
3 |
74 |
4A |
4 |
52 |
34 |
5 |
63 |
3F |
6 |
74 |
4A |
7 |
52 |
34 |
8 |
63 |
3F |
Decimal to Hexadecimal
=DEC2HEX(A2)
|
A |
B |
1 |
Decimal |
Hexadecimal |
2 |
56 |
38 |
3 |
74 |
4A |
4 |
52 |
34 |
5 |
63 |
3F |
6 |
74 |
4A |
7 |
52 |
34 |
8 |
63 |
3F |
Octal to Binary
=OCT2BIN(A2)
|
A |
B |
1 |
Octal |
Binary |
2 |
45 |
100101 |
3 |
67 |
110111 |
4 |
44 |
100100 |
5 |
62 |
110010 |
6 |
43 |
100011 |
7 |
64 |
110100 |
8 |
35 |
11101 |
Octal to Decimal
=OCT2DEC(A2)
|
A |
B |
1 |
Octal |
Decimal |
2 |
45 |
37 |
3 |
67 |
55 |
4 |
44 |
36 |
5 |
62 |
50 |
6 |
43 |
35 |
7 |
64 |
52 |
8 |
35 |
29 |
Octal to Hexadecimal
=OCT2HEX(A2)
|
A |
B |
1 |
Octal |
Hexadecimal |
2 |
45 |
25 |
3 |
67 |
37 |
4 |
44 |
24 |
5 |
62 |
32 |
6 |
43 |
23 |
7 |
64 |
34 |
8 |
35 |
1D |
Hexadecimal to Octal
=HEX2OCT(A2)
|
A |
B |
1 |
Hexadecimal |
Octal |
2 |
186A1 |
303241 |
3 |
1BC45 |
336105 |
4 |
1B207 |
331007 |
5 |
18A93 |
305223 |
6 |
1B1FD |
330775 |
7 |
18AF6 |
305366 |
8 |
186A1 |
303241 |
Hexadecimal to Decimal
=HEX2DEC(A2)
|
A |
B |
1 |
Hexadecimal |
Decimal |
2 |
186A1 |
100001 |
3 |
1BC45 |
113733 |
4 |
1B207 |
111111 |
5 |
18A93 |
101011 |
6 |
1B1FD |
111101 |
7 |
18AF6 |
101110 |
8 |
186A1 |
100001 |
No comments: