ID EN
#Engineering

OCT2DEC

Excel Functions

Converts an octal number to its decimal equivalent

Syntax

EXCEL
=OCT2DEC(number)

Arguments

Parameter Description
number The octal number you want to convert.

Return Value

A decimal number

Details

The OCT2DEC function is used to convert octal numbers (base 8) to decimal numbers (base 10). This is useful when working with different number systems, especially in engineering and computer science applications. To convert the octal number 10 to decimal, use the following formula: The spreadsheet below shows some basic conversions of octal numbers to decimal numbers: Excel represents negative numbers in non-decimal bases (like octal) using two's complement notation with a fixed width of 10 characters. For example, the decimal number -2 is represented as the octal number 7777777776. This is because Excel represents the number using 30 bits, where the first bit is used for the sign, and the remaining 29 bits represent the value. Octal numbers from 0 to 3777777777 represent positive numbers,

Examples

Example #1 - Basic conversion

To convert the octal number 10 to decimal, use the following formula:

EXCEL
=OCT2DEC(10) // returns 8
Example #2 - Negative octal numbers

Excel represents negative numbers in non-decimal bases (like octal) using two's complement notation with a fixed width of 10 characters. For example,

EXCEL
=OCT2DEC(7777777776) // returns -2

See Also

DEC2OCT OCT2BIN OCT2HEX