OCT2DEC(number, places)
places argument to be included in upcoming version
- Where 'number' is the octal number to be converted to decimal number.
OCT2DEC() converts an octal number to a decimal number.
Description
OCT2DEC(number)
For example,
OCT2DEC("") returns as a result.
OCT2DEC("") returns as a result.
- This function is used to convert an octal number to a decimal number.
- An Octal number uses digits from 0 to 9. The number can also be entered in text format (e.g "77").
- A number preceding with '0' (e.g 013) should be written in text format ("013") to avoid confusion with hexadecimal numbers.
- A number can be up to 10 characters (40 bits). The most significant bit is the sign bit and remaining are magnitude bits. A negative number is represented in 2's complement format.
- If the number is not a valid number, 'Calci' returns an #ERROR message.
Below are few examples that show the use of combination of functions and get the result in decimal -
1)SUM(OCT2DEC("") + OCT2DEC("")) returns as a result.
2)OCT2DEC("") - OCT2DEC("") returns as a result.