DEC2OCT
TheDEC2OCT
function is an Engineering function in Google Sheets that converts a decimal number to an octal number. The octal number is returned as a text string. The function is most commonly used to convert decimal numbers to octal numbers for use in various calculations and data analysis tasks.
 How to use
DEC2OCT
formula?  Examples of using
DEC2OCT
formula DEC2OCT
formula not working? Similar formulas to
DEC2OCT
Usage
Use the DEC2OCT
formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:
 decimal_number (required):
The decimal number to be converted to octal.  significant_digits (optional):
The number of significant digits to include in the octal number. If omitted, the default is 10 significant digits.
Examples
Here are a few example use cases that explain how to use theDEC2OCT
formula in Google Sheets.
Converting decimal numbers to octal numbers
The DEC2OCT
function is commonly used to convert decimal numbers to octal numbers for use in various calculations and data analysis tasks.
Converting decimal numbers to binary numbers
The DEC2OCT
function can be used in conjunction with other functions to convert decimal numbers to binary numbers.
Converting decimal numbers to hexadecimal numbers
The DEC2OCT
function can be used in conjunction with other functions to convert decimal numbers to hexadecimal numbers.
Common Mistakes
DEC2OCT
not working? Here are some common mistakes people make when using the DEC2OCT
Google Sheets Formula:
Incorrect number of arguments
One common mistake is not providing the correct number of arguments. The DEC2OCT formula requires at least one argument, the decimal number to be converted, and an optional second argument for significant digits.
Invalid input
Another mistake is providing an invalid input. The decimal number must be a valid number and the optional significant digits argument must be a positive integer between 1 and 10.
Incorrect use of significant digits
A common mistake is misunderstanding the purpose of the optional significant digits argument. This argument specifies the number of significant digits to include in the octal number, not the number of digits overall.
Related Formulas
The following functions are similar to DEC2OCT
or are often used with it in a formula:

OCT2DEC
The
OCT2DEC
function converts a signed octal number to its decimal equivalent. It takes one required parameter, the signed_octal_number, which is the signed octal number you want to convert to decimal. The function returns the decimal equivalent of the signed octal number. 
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. 
DEC2HEX
The
DEC2HEX
formula is an engineering formula in Google Sheets that converts a decimal number to its hexadecimal equivalent. It is commonly used to convert numbers to a format that is easier to read and work with in certain applications.
Learn More
You can learn more about the DEC2OCT
Google Sheets function on Google Support.