OCT2DEC function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
OCT2DEC
Converts an octal number to decimal.
This function is only available if the Analysis AddIn is installed.
Syntax:
OCT2DEC(octalnumber)
- returns a (decimal) number, given octalnumber, which may be text, or a number (taken to be octal, although it is not).
- octalnumber may have up to ten digit in twos complement representation; positive numbers are 0 to 3777777777 (representing 0 to 229-1 decimal) and negative numbers 7777777777 to 4000000000 (representing -1 to -229 decimal).
Example:
OCT2DEC("31")
- returns 25 as a (decimal) number.
OCT2DEC(31)
- returns 25 as a (decimal) number. The number 31 is read as octal.
OCT2DEC("7777777776")
- returns -2 as a (decimal) number.
See Also
