EXCEL OCT2DEC FUNCTION

The Oct2Dec function in Excel transforms an Octal (a base-8 value) to a decimal.

Syntax :

=OCT2DEC( number )

Parameters :

The number input represents the octal number to be converted to a decimal.

Step By Step Guide of OCT2DEC Function

Example :

The negative octal in cell A4 of the above example spreadsheet is represented using two’s complement notation.

  • #NUM! – This error occurs if the provided number argument is not an octal number or contains more than 10 characters.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now