Difference between revisions of "Manuals/calci/DEC2OCT"
Jump to navigation
Jump to search
| (7 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 | + | *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 ( | + | *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 | + | *'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. | ||
*If the 'number' is not an integer, Calci considers the integer part, and displays the output. | *If the 'number' is not an integer, Calci considers the integer part, and displays the output. | ||
| − | *Calci ignores the 'places' | + | *Calci ignores the 'places', if the output is more than mentioned 'places'. |
| − | *Calci ignores the 'places' | + | *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 32: | Line 38: | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class=" " | | + | | class=" " | '''Function''' |
| − | | | + | | class=" " | '''Octal Output''' |
| − | + | ||
| − | | | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | | class=" " | | + | | class="sshl_f" | DEC2OCT(512) |
| − | | class="sshl_f" | | + | | class="sshl_f" | 0000001000 |
| − | + | ||
| − | |||
| − | |||
|- class="even" | |- class="even" | ||
| − | | class=" | + | | class="sshl_f" | DEC2OCT(512,3) |
| − | | class=" | + | | class="sshl_f" | 1000 |
| − | + | ||
| − | |||
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | 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" | 0000017306 |
| − | | | + | |
| − | | | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | | class=" " | | + | | class="sshl_f" | DEC2OCT("-364") |
| − | + | | class="sshl_f" | 7777777224 | |
| − | | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | | ||
|} | |} | ||
| − | + | ==Related Videos== | |
| − | + | ||
| + | {{#ev:youtube|tYW7RpOX3_I|280|center|DEC2OCT}} | ||
| + | |||
| + | == See Also == | ||
| + | |||
| + | *[[Manuals/calci/DEC2BIN| DEC2BIN]] | ||
| + | |||
| + | *[[Manuals/calci/DEC2HEX| DEC2HEX]] | ||
| + | |||
| + | *[[Manuals/calci/OCT2DEC| OCT2DEC]] | ||
| + | |||
| + | ==References== | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Octal Octal Numbers] | ||
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 |