Difference between revisions of "Manuals/calci/DEC2OCT"

From ZCubes Wiki
Jump to navigation Jump to search
Line 3: Line 3:
 
*Where 'number' is the decimal number to be converted, and
 
*Where 'number' is the decimal number to be converted, and
  
*'places' is the number of characters.  
+
*'places' is the number of characters to display the output.  
  
 
DEC2OCT() is used to convert decimal number to its octal equivalent.
 
DEC2OCT() is used to convert decimal number to its octal equivalent.
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).
 +
*Output is a 40 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 (40 bit) hexadecimal number.
 +
*'places' argument can be omitted. Then, Calci displays the hexadecimal output with minimum number of characters necessary.
 +
*'places' is used for padding the output with leading '0's'.
  
If omitted then it use minimum number of characters.NumberPlace is use for adding to return value with leading zeros.
+
For Example,
 +
DEC2OCT(68,3)
 +
DEC2OCT(
 +
DEC2OCT(
  
</div>
+
*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.
<div id="1SpaceContent" class="zcontent" align="left">
+
*Calci ignores the 'places' to display the output, if the output is more than mentioned 'places'.
 +
*Calci ignores the 'places' to display the output, if the 'places' is non-numeric or negative.
 +
*If 'places' is not an integer, Calci truncates the 'places' value.
  
Calci converts a decimal number to octal.
 
 
</div>
 
----
 
<div id="7SpaceContent" class="zcontent" align="left">
 
 
If SomeNumber and NumberPlaces are non-numeric, DEC2BIN returns the#ERROR.
 
 
If the NumberPlaces is a negative, it returns the #ERROR.
 
 
If NumberPlaces &gt; LengthofSomeNumber then  returns #ERROR.
 
 
</div>
 
----
 
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
 
DEC2OCT
 
 
<font size="6"></font>
 
 
</div></div>
 
----
 
<div id="8SpaceContent" class="zcontent" align="left">
 
 
Lets see an example in (Column1, Row1)
 
 
<nowiki>=DEC2OCT(68,3)</nowiki>
 
 
DEC2OCT converts 68 to 104 upto 3 charcacters.
 
 
</div>
 
----
 
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
----
 
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
----
 
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
----
 
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
----
 
 
<div id="2SpaceContent" class="zcontent" align="left">
 
<div id="2SpaceContent" class="zcontent" align="left">
  

Revision as of 17:23, 17 November 2013

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 up to 20 digits (i.e. in-between -99999999999999999999 and -99999999999999999999).
  • Output is a 40 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 (40 bit) hexadecimal number.
  • 'places' argument can be omitted. Then, Calci displays the hexadecimal output with minimum number of characters necessary.
  • 'places' is used for padding the output with leading '0's'.

For Example, DEC2OCT(68,3) DEC2OCT( DEC2OCT(

  • 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' to display the output, if the output is more than mentioned 'places'.
  • Calci ignores the 'places' to display the output, if the 'places' is non-numeric or negative.
  • If 'places' is not an integer, Calci truncates the 'places' value.
Column1 Column2 Column3 Column4
Row1 104
Row2
Row3
Row4
Row5
Row6