Excel DEC2OCT Function

If you want to follow along with this tutorial, please download the example spreadsheet.

Description

The Excel DEC2OCT function converts a decimal number to an octal number.

Syntax and arguments

Formula syntax

Arguments

Return Value

The DEC2OCT function returns an octal number.

Error

1. Return #NUM! error if one of below states occurs:

• Argument number is > -536,870,912,888 or < 536,870,911;
• Argument places is provided not enough for the argument number, such as DEC2OCT(100,1) returns #NUM!, because the real result is 64;
• Argument places is < = 0.

2. Return #VALUE! error if any arguments of DEC2OCT function are non-numeric values.

Version

Excel 2003 and later

Usage and Examples

Example: Basic Usage

Decimal numbers and places are listed in range B5:B11, to get the corresponding octal numbers based on the places in cell C5:C11, please copy or enter the below formula to the next cell of the range:

=DEC2OCT(B4,C4)

Press Enter key and drag the autofill handle down to get all octal numbers.

If you just use the formula once, you also can directly type arguments in the formula:

=DEC2OCT(0,1)

Relative Functions:

• Excel DEC2BIN Function
  The Excel DEC2BIN function converts a decimal number to a binary number.

• Excel DEC2HEX.S Function
  The Excel DEC2BIN function converts a decimal number to a hex number.

• Excel STDEV.P Function
  The Excel STDEV.P function returns standard deviation based on the entire population.

• Excel STDEVP Function
  The Excel STDEVP function returns standard deviation based on the entire population.