Help Centre › Functions & 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
| Formula | Description | Result |
| =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.