Difference between revisions of "Manuals/calci/OCT2DEC"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| Line 1: | Line 1: | ||
| − | + | =OCT2DEC(number, places)= | |
| − | + | <font color="red">places argument to be included in upcoming version</font> | |
| − | + | *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. | |
| − | + | == Examples == | |
| − | + | <div id="2SpaceContent" class="zcontent" align="left"> | |
| − | |||
| − | <div id=" | ||
| − | {| id=" | + | {| id="TABLE3" class="SpreadSheet blue" |
|- class="even" | |- class="even" | ||
| − | | class=" " | | + | | class=" " | '''Octal Input''' |
| − | | | + | | class=" " | '''Decimal Output''' |
| − | + | ||
| − | | | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | | class=" " | | + | | class="sshl_f" | |
| − | | class="sshl_f" | | + | | class="sshl_f" | |
| − | + | ||
| − | |||
| − | |||
|- class="even" | |- class="even" | ||
| − | | class=" | + | | class="ssh1_f" | |
| − | + | | class="sshl_f" | | |
| − | | class=" sshl_f | + | |
| − | |||
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="ssh1_f" | | |
| − | | class=" | + | | class="sshl_f" | |
| − | | class=" " | | + | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|- class="even" | |- class="even" | ||
| − | + | | class="ssh1_f" | | |
| − | + | | class="sshl_f" | | |
| − | |||
| − | | class=" " | | ||
| − | | class=" " | | ||
|} | |} | ||
| − | + | == See Also == | |
| − | + | ||
| + | *[[Manuals/calci/DEC2HEX| DEC2HEX]] | ||
| + | |||
| + | *[[Manuals/calci/HEX2BIN| HEX2BIN]] | ||
| + | |||
| + | *[[Manuals/calci/HEX2OCT| HEX2OCT]] | ||
| + | |||
| + | *[[Manuals/calci/BIN2HEX| BIN2HEX]] | ||
| + | |||
| + | *[[Manuals/calci/OCT2HEX| OCT2HEX]] | ||
| + | |||
| + | ==References== | ||
| + | *[http://simple.wikipedia.org/wiki/Octal_numeral_system#Octal_and_decimal Octal to Decimal Conversion] | ||
Revision as of 17:03, 10 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("") 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.