DEC2OCT Function in Excel

In this article, you will learn about the DEC2OCT function, its usage, syntax and how to use it in your excel spreadsheet.

DEC2OCT Function in Excel

The DEC2OCT function in Excel converts a decimal number to its octal values.

Similar to the BIN2DEC and BIN2OCT, in DEC2OCT the input numbers must contain only zeros and ones and it is restricted to only 10 characters, and if the value crosses the 10 character limit the function will return “#NUM!” Error.

Syntax

=DEC2OCT(number, [places])

Arguments:

  • Number   – The decimal number you want to convert.
  • Places    [optional]

When left out or neglected, it uses the least number of characters required to represent the number, or else it combines the result with zeros up to the specified number of places.

Possible Errors

When the entered number is not a valid decimal number, or the number contains more than 10 characters (10 bits), DEC2OCT returns the #NUM! error value.

And when the entered number is negative, DEC2OCT ignores places and returns a 10-character octal number.

When DEC2OCT requires more than places characters, it returns the #NUM! error value.

And when the ‘places’ is not an integer, it will be truncated.

When the ‘places’ is nonnumeric, DEC2OCT returns the #VALUE! error value.

When the ‘places’ is negative, DEC2OCT returns the #NUM! error value.

How to use the DEC2OCT in Excel?

Using this function in a Worksheet is simple; all you need to do is enter the function as a formula of the cell in the formula bar.

Take a look at the given example:

How to use the DEC2OCT in Excel?

The above example contains the decimal numbers with their own octal values. To find out the octal numbers, enter the given decimal numbers in column A and in Column B enter the number of places, and in Column C, enter the following formula

Formula: =DEC2OCT(A1,B1)

Here, A1 refers to the cell name or the cell address. Repeat the same to the other cells and you will get the octal value of the decimal numbers.