How to use OCT2DEC Function in Excel

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:

OCT2DEC Function - How to use OCT2DEC Function in Excel

Syntax:  =OCT2DEC(A2)


OCT2DEC Function in Excel - How to use OCT2DEC Function in Excel

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

Add a Comment

Your email address will not be published. Required fields are marked *