## 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) |