Related Function:

The OCT2DEC function converts an octal number into a decimal number.

Syntax

=OCT2DEC(number)

Note: Hexadecimal (base 16), decimal (base 10), octal (base 8), and binary (base 2) are the most commonly used numeral systems in engineering and computing. Therefore, Excel has provided functions to convert numeric values to and from each of these systems.

Arguments

Argument Description
number The octal number you want to convert

  The number may not contain more than 10 octal characters (30 bits)
  The most significant bit of number is the sign bit
  The remaining 29 bits are magnitude bits
  Negative numbers are represented using two’s-complement notation

Examples

  A B C
1 Formula Result Notes
2 =OCT2DEC(54) 44 Converts octal 54 to decimal form
3 =OCT2DEC(7777777533) -165 Converts octal 7777777533 to decimal form
4 =OCT2DEC(“355”) 237 Converts octal 355 to decimal form

Common Function Error(s)

Problem What went wrong
#NUM! Occurs if either:

  the supplied number argument is not recognised as a octal number
  the supplied number argument contains more than 10 characters
#NAME? Occurs when Analysis ToolPak add-in is not enabled