Formulas > =BIN2OCT()

How To Use BIN2OCT() Function in Google Sheets


Converts a signed binary number to signed octal format.

Common questions about the BIN2OCT formula include:

- What is the BIN2OCT formula used for?
- How is the BIN2OCT formula written? 
- How do you use the BIN2OCT formula in Google Sheets?

The BIN2OCT formula is used to convert a binary number into its equivalent Octal value. It is written as =BIN2OCT(number).

To use it appropriately, the formula should be used with binary numbers that only contain 0s and 1s. Additionally, the argument should be an integer value with up to an 8-digit binary number.

The BIN2OCT formula can be commonly mistyped as =BI2NOCT or BIN2OCT (number).

Common ways the BIN2OCT formula is used inappropriately include:
- Using the BIN2OCT formula with numbers that are not binary
- Entering the BIN2OCT formula with characters other than 0s and 1s
- Passing a binary number with more than 8 digits

Common pitfalls when using the BIN2OCT formula include:
- Forgetting to use the BIN2OCT formula to convert a number from binary to octal
- Incorrectly using the BIN2OCT formula with a number that is not binary
- Misunderstanding that the BIN2OCT formula only works with 8-digit binary numbers

Common mistakes when using the BIN2OCT formula include:
- Incorrectly using the BIN2OCT formula for short binary numbers
- Forgetting to use the BIN2OCT formula for longer binary numbers
- Misunderstanding that the BIN2OCT formula only works with binary numbers

Common misconceptions people might have with the BIN2OCT Formula include:
- Thinking that the BIN2OCT formula can be used to convert numbers from any base to octal
- Believing that the BIN2OCT formula can be used with any type of number
- Assuming that the BIN2OCT formula works with different numerical bases

How To Actually Use BIN2OCT() in Sheets

BIN2OCT(signed_binary_number, [significant_digits])

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the BIN2OCT() formula:

Google Sheet: Number Base Functions

How to convert numbers between different number bases in Google Sheet. The video looks at the generic functions - DECIMAL and BASE which convert from any number base between 2 & 36 and decimal. The video focuses on conversions between the most common number bases using the functions DEC2BIN, DEC2OCT, DEC2HEX, HEX2DEC, OCT2DEC and BIN2DEC. The video demonstrates that Google Sheet can only add, subtract etc numbers in base 10 and shows how sometimes Google Sheet can give the incorrect impression that it can add and subtract numbers in other number bases. Finally the video looks at the maximum and minimum values allowed by each conversion.

Generate a BIN2OCT() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.