Check Sheet Logo
Check Sheet

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:

=OCT2DEC(signed_octal_number)
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.

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.