OCT2DEC
TheOCT2DEC
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.
 How to use
OCT2DEC
formula?  Examples of using
OCT2DEC
formula OCT2DEC
formula not working? Similar formulas to
OCT2DEC
Usage
Use the OCT2DEC
formula with the syntax shown below, it has 1 required parameter:
 signed_octal_number (required):
The signed octal number you want to convert to decimal.
Examples
Here are a few example use cases that explain how to use theOCT2DEC
formula in Google Sheets.
Converting octal numbers to decimal
Suppose you have a set of signed octal numbers that you need to convert to decimal, you can use the OCT2DEC
function to do this quickly and easily.
Working with legacy systems
The OCT2DEC
function is particularly useful when working with legacy systems that store data in octal format.
Converting Unix file permissions
Unix file permissions are often represented in octal format. You can use the OCT2DEC
function to convert these permissions to decimal format, which is easier to read and understand.
Common Mistakes
OCT2DEC
not working? Here are some common mistakes people make when using the OCT2DEC
Google Sheets Formula:
Incorrect input type
The input argument must be a signed octal number represented as text. If the input is not in this format, the formula will return an error. Check that the input is in the correct format and convert it to text if necessary.
Missing input argument
The OCT2DEC formula requires an input argument. If the input is missing or the cell is empty, the formula will return an error. Check that the input cell has a valid value and is not empty.
Invalid signed octal number
The input argument must be a valid signed octal number represented as text. If the input number is not valid, the formula will return an error. Check that the input number is in the correct format and does not contain any invalid characters.
Negative input number
The OCT2DEC formula only works with signed octal numbers. If the input number is negative, the formula will return an error. Check that the input number is in the correct format and is not negative.
Number too large
The OCT2DEC formula can only convert octal numbers up to 10 digits in length. If the input number is too large, the formula will return an error. Check that the input number is not too large and can be converted to decimal format.
Related Formulas
The following functions are similar to OCT2DEC
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. 
HEX2DEC
The
HEX2DEC
function converts a signed hexadecimal number to its decimal equivalent. This function is commonly used in engineering calculations where hexadecimal numbers are used to represent signed values. 
DEC2OCT
The
DEC2OCT
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. 
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 OCT2DEC
Google Sheets function on Google Support.