Excel DEC2OCT function

Function              DEC2OCT

Description        Excel DEC2OCT function converts Decimal number system to Octal number system.

Syntax                  DEC2OCT(number, [places])

Number               is the decimal number

[places]               Optional. Which specifies the number of characters that you want the returned octal number to have. If omitted returns the least number of characters required to represent the number.

Example:

Usage Notes:

• If Number is less than -536,870,912 (-2^29) or grater than 536,870,911 (2^29-1), DEC2OCT returns the #NUM! error value.
• If Number is non-numeric, DEC2OCT returns the #VALUE! error value.
• If the result of DEC2OCT requires more than the number of specified Places characters, it returns the #NUM! error value.
• If places is not an integer, it shows #NAME? error.
• If Places is non-numeric, DEC2OCT returns the #VALUE! error value.
• If Places is negative, DEC2OCT returns the #NUM! error value.