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

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.

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