OCT2BIN Function in Google Sheets

Convert an octal number to a binary number using the OCT2BIN function.

OCT2BIN Function

The OCT2BIN function in Google Sheets converts an octal number to its binary equivalent.

Syntax

OCT2BIN(signed_octal_number, [significant_digits])
  • signed_octal_number: The octal number you want to convert. This is a required parameter.
  • significant_digits: (Optional) The number of digits you want the binary number to contain.

Examples

  1. Basic Conversion

Convert the octal number 17 to binary:

=OCT2BIN(17)

This will output 1111.

  1. Conversion with Significant Digits

Convert the octal number 17 to binary with 6 significant digits:

=OCT2BIN(17, 6)

This will output 001111.

Notes

  • The function can handle octal numbers up to 30 bits.
  • If significant_digits is provided, the binary result will be padded with leading zeros to match the specified length.
  • OCT2DEC: Convert an octal number to a decimal number.
  • OCT2HEX: Convert an octal number to a hexadecimal number.