# 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.

## Usage

Use the `OCT2DEC` formula with the syntax shown below, it has 1 required parameter:

Parameters:
1. 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 the `OCT2DEC` 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.

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.

You can learn more about the `OCT2DEC` Google Sheets function on Google Support.