Difference between revisions of "Manuals/calci/DEC2OCT"
Jump to navigation
Jump to search
| (5 intermediate revisions by the same user not shown) | |||
| Line 11: | Line 11: | ||
DEC2OCT(number, places) | DEC2OCT(number, places) | ||
| − | *The 'number' can be | + | *The 'number' can be in-between -536870912 and 536870911, else Calci displays a #NUM! error. |
*Output is a 30 bit number. The most significant bit is the sign bit and remaining bits are magnitude bits. | *Output is a 30 bit number. The most significant bit is the sign bit and remaining bits are magnitude bits. | ||
*If 'number' is negative, Calci ignores the places and returns a 10 character (30 bit) octal number. | *If 'number' is negative, Calci ignores the places and returns a 10 character (30 bit) octal number. | ||
*'places' argument can be omitted. Then, Calci displays the octal output with minimum number of characters necessary. | *'places' argument can be omitted. Then, Calci displays the octal output with minimum number of characters necessary. | ||
*'places' is used for padding the output with leading '0's'. | *'places' is used for padding the output with leading '0's'. | ||
| + | *A number preceding with '0' (e.g. 0377) should be written in text format ("0377") to avoid confusion with octal numbers. | ||
For Example, | For Example, | ||
| − | DEC2OCT(68,3) | + | |
| − | DEC2OCT( | + | DEC2OCT(68,3) ''returns 104'' |
| − | DEC2OCT( | + | |
| + | DEC2OCT(99) ''returns 0000000143'' | ||
| + | |||
| + | DEC2OCT(99.45) ''returns 0000000143'' | ||
*Calci displays an error message, if the 'number' is an invalid decimal number. | *Calci displays an error message, if the 'number' is an invalid decimal number. | ||
| Line 27: | Line 31: | ||
*Calci ignores the 'places', if the 'places' is non-numeric or negative. | *Calci ignores the 'places', if the 'places' is non-numeric or negative. | ||
*If 'places' is not an integer, Calci truncates the 'places' value. | *If 'places' is not an integer, Calci truncates the 'places' value. | ||
| + | |||
| + | == Examples == | ||
<div id="2SpaceContent" class="zcontent" align="left"> | <div id="2SpaceContent" class="zcontent" align="left"> | ||
| Line 37: | Line 43: | ||
|- class="odd" | |- class="odd" | ||
| class="sshl_f" | DEC2OCT(512) | | class="sshl_f" | DEC2OCT(512) | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | 0000001000 |
|- class="even" | |- class="even" | ||
| class="sshl_f" | DEC2OCT(512,3) | | class="sshl_f" | DEC2OCT(512,3) | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | 1000 |
|- class="odd" | |- class="odd" | ||
| class="sshl_f" | DEC2OCT(2378,-4) | | class="sshl_f" | DEC2OCT(2378,-4) | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | 4512 |
|- class="even" | |- class="even" | ||
| class="sshl_f" | DEC2OCT(7878.78) | | class="sshl_f" | DEC2OCT(7878.78) | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | 0000017306 |
|- class="odd" | |- class="odd" | ||
| class="sshl_f" | DEC2OCT("-364") | | class="sshl_f" | DEC2OCT("-364") | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | 7777777224 |
|} | |} | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|tYW7RpOX3_I|280|center|DEC2OCT}} | ||
== See Also == | == See Also == | ||
Latest revision as of 14:22, 17 April 2015
DEC2OCT(number, places)
- Where 'number' is the decimal number to be converted, and
- 'places' is the number of characters to display the output.
DEC2OCT() is used to convert decimal number to its octal equivalent.
Description
DEC2OCT(number, places)
- The 'number' can be in-between -536870912 and 536870911, else Calci displays a #NUM! error.
- Output is a 30 bit number. The most significant bit is the sign bit and remaining bits are magnitude bits.
- If 'number' is negative, Calci ignores the places and returns a 10 character (30 bit) octal number.
- 'places' argument can be omitted. Then, Calci displays the octal output with minimum number of characters necessary.
- 'places' is used for padding the output with leading '0's'.
- A number preceding with '0' (e.g. 0377) should be written in text format ("0377") to avoid confusion with octal numbers.
For Example,
DEC2OCT(68,3) returns 104
DEC2OCT(99) returns 0000000143
DEC2OCT(99.45) returns 0000000143
- Calci displays an error message, if the 'number' is an invalid decimal number.
- If the 'number' is not an integer, Calci considers the integer part, and displays the output.
- Calci ignores the 'places', if the output is more than mentioned 'places'.
- Calci ignores the 'places', if the 'places' is non-numeric or negative.
- If 'places' is not an integer, Calci truncates the 'places' value.
Examples
| Function | Octal Output |
| DEC2OCT(512) | 0000001000 |
| DEC2OCT(512,3) | 1000 |
| DEC2OCT(2378,-4) | 4512 |
| DEC2OCT(7878.78) | 0000017306 |
| DEC2OCT("-364") | 7777777224 |