BIN2OCT
TheBIN2OCT
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.
 How to use
BIN2OCT
formula?  Examples of using
BIN2OCT
formula BIN2OCT
formula not working? Similar formulas to
BIN2OCT
Usage
Use the BIN2OCT
formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:
 signed_binary_number (required):
The binary number you want to convert to octal format.  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 theBIN2OCT
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.
Related Formulas
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.