## Engineering functions for number conversions in various bases

#### Excel Function OCT2BIN

The OCT2BIN() function is used to convert octal number to binary notation.

The octal number has a base value of 8 and binary has a base value of 2.

This function is also most often used in digital computation.

 Octal Binary Formula 45 100101 =OCT2BIN(L4) 76 111110 =OCT2BIN(L5) 4 100 =OCT2BIN(L6) 7 111 =OCT2BIN(L7) 23 10011 =OCT2BIN(L8) 8 #NUM! =OCT2BIN(L9)

As seen above, the number 8 results in error since octal has numbers from 0 to 7 only.

#### Excel Function OCT2DEC

The OCT2DEC() function is used to calculate decimal value of a given octal number.

This function is used to convert the octal number into base-10 notation.

 Octal Decimal Formula 45 37 =OCT2DEC(L18) 76 62 =OCT2DEC(L19) 4 4 =OCT2DEC(L20) 7 7 =OCT2DEC(L21) 23 19 =OCT2DEC(L22) 65 53 =OCT2DEC(L23)

#### Excel Function OCT2HEX

The OCT2HEX() function is used to convert octal number to hexadecimal form.

This function converts the number to base-16 form.

This function is most used with microprocessor problems.

 Octal Hex Formula 45 25 =OCT2HEX(L30) 76 3E =OCT2HEX(L31) 4 4 =OCT2HEX(L32) 7 7 =OCT2HEX(L33) 23 13 =OCT2HEX(L34) 65 35 =OCT2HEX(L35)

#### Excel Function HEX2BIN

The HEX2BIN() function is used to convert hexadecimal number to binary notation.

The hexadecimal number has a base value of 16 and binary has a base value of 2.

This function is also most often used in digital computation.

 Hex Binary Formula 25 100101 =HEX2BIN(L44) 3E 111110 =HEX2BIN(L45) 4 100 =HEX2BIN(L46) 7 111 =HEX2BIN(L47) 13 10011 =HEX2BIN(L48) 35 110101 =HEX2BIN(L49)

#### Excel Function HEX2DEC

The HEX2DEC() function is used to calculate decimal value of a given hexadecimal number.

This function is used to convert the hexadecimal number into base-10 notation.

 Hex Decimal Formula 25 37 =HEX2DEC(L57) 3E 62 =HEX2DEC(L58) 4 4 =HEX2DEC(L59) 7 7 =HEX2DEC(L60) 13 19 =HEX2DEC(L61) 35 53 =HEX2DEC(L62)

#### Excel Function HEX2OCT

The HEX2OCT() function is used to convert hexadecimal number to octal form.

This function converts the number to base-8 form.

This function is most used with microprocessor problems where reversing of opcode is required.

 Hex Octal Formula 25 45 =HEX2OCT(L70) 3E 76 =HEX2OCT(L71) 4 4 =HEX2OCT(L72) 7 7 =HEX2OCT(L73) 13 23 =HEX2OCT(L74) 35 65 =HEX2OCT(L75)