The Excel Oct2Dec function converts an Octal (a base-8 number) into a decimal number
Syntax:= OCT2DEC(number)
The OCT2DEC function syntax has the following arguments:
- Number: Required. The octal number you want to convert. 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
Example: Let’s look at some Excel OCT2DEC function examples and explore how to use the OCT2DEC function as a worksheet function in Microsoft Excel:
Syntax: =OCT2DEC(A2)
Result:
Based on the Excel spreadsheet above, the following OCT2DEC examples would return:
Syntax: =OCT2DEC(A3)
Result: 64
Syntax: =OCT2DEC(A4)
Result: 237
Syntax: =OCT2DEC(A5)
Result: 147
Syntax: =OCT2DEC(A6)
Result: 128
Syntax: =OCT2DEC(A7)
Result: 44
Syntax: =OCT2DEC(A8)
Result: -165
Syntax: =OCT2DEC(A9)
Result: 190
Syntax: =OCT2DEC(A10)
Result: 134217726
Syntax: =OCT2DEC(A11)
Result: 5349
Syntax: =OCT2DEC(A12)
Result: 11
Syntax: =OCT2DEC(A13)
Result: 134217728
Syntax: =OCT2DEC(A14)
Result: 21
Syntax: =OCT2DEC(A15)
Result: 12
Note: If number is not a valid octal number, OCT2DEC returns the #NUM! error value
