Converts an octal number to a decimal number.
Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.
OCT2DEC(number)The OCT2DEC function takes an octal string and returns its decimal equivalent. It is useful for converting base-8 numerical data into standard base-10 format for calculations.
=OCT2DEC("17")Résultat : 15
Converts the octal value 17 to its decimal equivalent, which is 15.
=OCT2DEC(54)Résultat : 44
Converts the octal value 54 to its decimal equivalent, which is 44.
The number cannot contain more than 10 octal characters, and the most significant bit is the sign bit.
The function will return a #NUM! error if the input contains digits other than 0-7.