Difference between revisions of "Manuals/calci/DEC2OCT"

From ZCubes Wiki
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 11: Line 11:
 
DEC2OCT(number, places)
 
DEC2OCT(number, places)
  
*The 'number' can be up to 20 digits (i.e. in-between -99999999999999999999 and -99999999999999999999).
+
*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,
Line 30: 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 58: Line 61:
 
| class="sshl_f" | 7777777224
 
| class="sshl_f" | 7777777224
 
|}
 
|}
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|tYW7RpOX3_I|280|center|DEC2OCT}}
  
 
== See Also ==
 
== See Also ==

Latest revision as of 15: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

Related Videos

DEC2OCT

See Also

References