Check Sheet Logo
Check Sheet

BIN2OCT

The BIN2OCT function converts a signed binary number to octal format. It takes one required parameter, signed_binary_number, which is the binary number you want to convert. The optional parameter, significant_digits, is an integer specifying the number of digits you want to include in the result. If you omit this parameter, Google Sheets assumes a default of 10 significant digits.

Usage

Use the BIN2OCT formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:

=BIN2OCT(signed_binary_number, [significant_digits])
Parameters:
  1. signed_binary_number (required):
    The binary number you want to convert to octal format.
  2. significant_digits (optional):
    Optional. An integer specifying the number of digits you want to include in the result. If omitted, Google Sheets assumes a default of 10 significant digits.

Examples

Here are a few example use cases that explain how to use the BIN2OCT formula in Google Sheets.

Converting a binary number to octal format

Suppose you have a binary number in cell A1 that you want to convert to octal format. You can use the formula =BIN2OCT(A1) to get the octal equivalent of the binary number.

Specifying the number of significant digits in the result

By default, the BIN2OCT function assumes 10 significant digits in the result. You can change this by specifying the significant_digits parameter. For example, =BIN2OCT(A1, 4) will return an octal number with only 4 significant digits.

Common Mistakes

BIN2OCT not working? Here are some common mistakes people make when using the BIN2OCT Google Sheets Formula:

Incorrect binary number format

The signed_binary_number argument must be a valid binary number. Ensure that it only contains 0s and 1s.

Missing signed_binary_number argument

Ensure that the signed_binary_number argument is provided and is not empty.

Incorrect significant_digits value

The significant_digits argument must be a positive integer between 1 and 10, inclusive. Ensure that it is a valid value.

The following functions are similar to BIN2OCT or are often used with it in a formula:

  • BIN2DEC

    The BIN2DEC formula is an engineering formula used to convert a signed binary number to a decimal number. This formula is commonly used in computer science and engineering fields.

  • BIN2HEX

    The BIN2HEX function converts a signed binary number to hexadecimal format. This function is commonly used in engineering and scientific fields where binary numbers are used to represent data. The output of this function is a text string in hexadecimal format.

  • DEC2BIN

    The DEC2BIN formula is used to convert a decimal number to a binary number. This is commonly used in engineering and computer science to represent numbers in their binary form. The formula takes in a decimal number and an optional number of significant digits to include in the binary representation.

  • HEX2BIN

    The HEX2BIN function is an Engineering function that converts a signed hexadecimal number to a signed binary number. It returns a text string and is commonly used in computer science and engineering fields.

Learn More

You can learn more about the BIN2OCT Google Sheets function on Google Support.