Difference between revisions of "Manuals/calci/OCT2DEC"
Jump to navigation
Jump to search
Line 15: | Line 15: | ||
OCT2DEC("100") ''returns 64'' as a result. | OCT2DEC("100") ''returns 64'' as a result. | ||
− | OCT2DEC("") ''returns '' as a result. | + | OCT2DEC("500") ''returns '320' as a result. |
*This function is used to convert an octal number to a decimal number. | *This function is used to convert an octal number to a decimal number. | ||
Line 21: | Line 21: | ||
*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. | *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. | *If the number is not a valid number, 'Calci' returns an #ERROR message. | ||
− | *A number preceding with '0' (e.g 013) should be written in text format ("013") to avoid confusion with hexadecimal numbers. | + | *A number preceding with '0' (e.g 013) should be written in text format ("013") to avoid confusion with hexadecimal numbers. |
+ | *If number is not an integer, Calci truncates the value to calculate the output. | ||
Below are few examples that show the use of combination of functions and get the result in decimal - | Below are few examples that show the use of combination of functions and get the result in decimal - | ||
− | 1)SUM(OCT2DEC("") | + | 1)SUM(OCT2DEC("65"), OCT2DEC("11")) ''returns 62'' as a result. |
− | 2)OCT2DEC("") - OCT2DEC("") ''returns '' as a result. | + | 2)OCT2DEC("654") - OCT2DEC("54") ''returns 384'' as a result. |
== Examples == | == Examples == | ||
Line 38: | Line 39: | ||
|- class="odd" | |- class="odd" | ||
− | | class="sshl_f" | | + | | class="sshl_f" | OCT2DEC("15") |
− | | class="sshl_f" | | + | | class="sshl_f" | 13 |
|- class="even" | |- class="even" | ||
− | | class="ssh1_f" | | + | | class="ssh1_f" | OCT2DEC("40.44") |
− | | class="sshl_f" | | + | | class="sshl_f" | 32 |
|- class="odd" | |- class="odd" | ||
− | | class="ssh1_f" | | + | | class="ssh1_f" | OCT2DEC("-55") |
− | + | | class="sshl_f" | -45 | |
− | |||
− | |||
− | |||
− | | class="sshl_f" | | ||
|} | |} | ||
== See Also == | == See Also == | ||
− | *[[Manuals/calci/ | + | *[[Manuals/calci/DEC2OCT| DEC2OCT]] |
− | *[[Manuals/calci/ | + | *[[Manuals/calci/OCT2BIN| OCT2BIN]] |
− | |||
− | |||
− | |||
− | |||
*[[Manuals/calci/OCT2HEX| OCT2HEX]] | *[[Manuals/calci/OCT2HEX| OCT2HEX]] | ||
==References== | ==References== | ||
+ | |||
*[http://simple.wikipedia.org/wiki/Octal_numeral_system#Octal_and_decimal Octal to Decimal Conversion] | *[http://simple.wikipedia.org/wiki/Octal_numeral_system#Octal_and_decimal Octal to Decimal Conversion] |
Revision as of 09:52, 11 December 2013
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("100") returns 64 as a result.
OCT2DEC("500") returns '320' as a result.
- This function is used to convert an octal number to a decimal number.
- The 'number' should be in the range '7777777000' for negative numbers (DEC -512) to '777' for positive numbers (DEC 511).
- 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.
- A number preceding with '0' (e.g 013) should be written in text format ("013") to avoid confusion with hexadecimal numbers.
- If number is not an integer, Calci truncates the value to calculate the output.
Below are few examples that show the use of combination of functions and get the result in decimal -
1)SUM(OCT2DEC("65"), OCT2DEC("11")) returns 62 as a result.
2)OCT2DEC("654") - OCT2DEC("54") returns 384 as a result.
Examples
Octal Input | Decimal Output |
OCT2DEC("15") | 13 |
OCT2DEC("40.44") | 32 |
OCT2DEC("-55") | -45 |