Engineering - OCT2DEC Function

Description

The OCT2DEC function converts an octal number to decimal.

Syntax

OCT2DEC (number)

Arguments

Argument	Description	Required/ Optional
Number	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.	Required

Argument

Description

Required/ Optional

Number

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.

Required

Notes

If number is not recognized as an octal number, or contains more than 10 characters, OCT2DEC returns the #NUM! Error value.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

advanced_excel_engineering_functions.htm