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