Formulas > =OCT2BIN()

How To Use OCT2BIN() Function in Google Sheets


Converts a signed octal number to signed binary format.

Common questions about the OCT2BIN formula include: What does the OCT2BIN formula do? How does the OCT2BIN formula work?

The OCT2BIN formula can be used appropriately to convert octal numbers to binary numbers in Google Sheets.

The OCT2BIN formula can be commonly mistyped as OCT2BINN.

Some common ways the OCT2BIN formula is used inappropriately are attempting to pass it a non-octal number, or using it with a incorrect data type such as text.

Common pitfalls when using the OCT2BIN formula include not paying attention to the formatting of the data being converted, as well as not noting the length of the binary number output.

Common mistakes when using the OCT2BIN Formula are entering the wrong octal number, entering an invalid number/data type, and forgetting to specify the output length of the binary number.

Common misconceptions people might have with the OCT2BIN Formula are that it can convert any data type to binary, or that it can convert decimal numbers.

How To Actually Use OCT2BIN() in Sheets

OCT2BIN(signed_octal_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 OCT2BIN() formula:

Google Sheet: Number Base Functions

ow 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 OCT2BIN() 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.