Calc OCT2DEC function

Converts an octal number to decimal.

Help CentreFunctions & Formulas

For a full list of available calculation functions, please read What calculation functions are supported.

This article describes the formula syntax and usage of the OCT2DEC function.


Description

Converts an octal number to decimal.


Syntax

OCT2DEC(number)


The OCT2DEC function syntax has the following argument:
  • number - Required. The octal number you want to convert. The number cannot contain more than 10 characters (the most significant bit is the sign bit).

Remarks

  • Number is interpreted as a signed number in octal notation. Valid numbers are from 0 to 7777777777 (octal), which is equivalent to 0 to 536870911 (decimal) for positive numbers, and from -1 to -2000000000 (octal), which is equivalent to -1 to -536870912 (decimal) for negative numbers.
  • If number is not a valid octal number, OCT2DEC returns the #NUM! error value.
  • If number is negative, OCT2DEC uses two's-complement notation to represent the decimal number.

Example

FormulaDescriptionResult
=OCT2DEC(17)Converts octal 17 to decimal.15
=OCT2DEC(-17)Converts negative octal 17 to decimal.-15

Errors

For a full list of formula errors, please read Formula errors.


Related functions

See it working on your own data

Everything documented here ships with the platform – try the document tools free, or go live in 7 days.