Difference between revisions of "Manuals/calci/HEX2OCT"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''HEX2OCT'''(SomeNumber, NumberPlaces) where, '''SomeNumber''' - is the hexadecimal number. '''NumberPlac...")
 
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
=HEX2OCT(number,places)=
  
−
'''HEX2OCT'''(SomeNumber, NumberPlaces)
+
*Where 'number' is a hexadecimal number to be converted and
 +
*'places' is the number of characters to be used to display the output.
  
−
where,
+
HEX2OCT converts a hexadecimal number to its octal equivalent.
  
−
'''SomeNumber''' - is the hexadecimal number.
+
== Description ==
  
−
'''NumberPlaces''' - is the number of characters.If omitted then it use minimum number of characters.NumberPlace is use for adding to return value with leading zeros.
+
HEX2OCT(number,places)
  
−
</div>
+
For Example,
−
----
 
−
<div id="1SpaceContent" class="zcontent" align="left">
 
  
−
Calci converts a hexadecimal number to octal.
+
HEX2OCT("A",4) ''returns '0012'
  
−
</div>
+
HEX2OCT("") ''returns ''
−
----
 
−
<div id="7SpaceContent" class="zcontent" align="left">
 
  
−
If SomeNumber and NumberPlaces are non-numeric, HEX2BIN returns the#ERROR.
+
HEX2OCT("") ''returns ''
  
−
If the NumberPlaces is a negative, it returns the #ERROR.
 
  
−
If NumberPlaces &gt; LengthofSomeNumber then  returns #ERROR.
+
*'number' must be a hexadecimal number. Hexadecimal number uses digits 0 to 9 and characters A to F. The number can also be entered in text format (e.g "1F").
  
−
If number is not valid hexadecimal number, it returns NaN.
+
*The most significant bit represents the 'sign' of the number. Negative numbers are represented using 2's complement notation.
  
−
</div>
+
*A number preceding with '0' (e.g 013) should be written in text format ("013") to avoid confusion with octal numbers.
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
HEX2OCT
+
*Calci returns an #ERROR message if 'number' contains more than 10 characters (10 bits).
 +
<font color = red> Need to verify the 'limit for no. of input digits' after next release </font>
  
−
<font size="6"></font>
+
*If 'number' is negative, Calci ignores the places and displays 10 digit octal output.
  
−
</div></div>
+
*If 'places' is not an integer, it is truncated.
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left">
 
  
−
Lets see an example in (Column1, Row1)
+
*If 'places' are non-numeric, Calci returns an #ERROR message.
  
−
<nowiki>=HEX2OCT("A",4)</nowiki>
+
*If 'places' is negative, Calci ignores the places and displays the octal output.
  
−
HEX2OCT converts A to 0012 upto 4 charcacters.
+
== Examples ==
−
 
 
−
Consider an another example(Column1, Row2)
 
−
 
 
−
<nowiki>=HEX2OCT("2BEA")</nowiki>
 
−
 
 
−
It converts into 25752.
 
−
 
 
−
</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">
 
  
 
{| id="TABLE3" class="SpreadSheet blue"
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
|- class="even"
−
| class=" " |
+
| class=" " | '''HEX Input'''
−
| Column1
+
| class="  " | '''Octal Output'''
−
| Column2
+
 
−
| Column3
 
−
| Column4
 
 
|- class="odd"
 
|- class="odd"
−
| class=" " | Row1
+
| class="sshl_f" |  
−
| class="sshl_f" | 12
+
| class="sshl_f" |  
−
| class=" " |
+
 
−
| class=" " |
 
−
| class=" " |
 
 
|- class="even"
 
|- class="even"
−
| class=" " | Row2
+
| class="ssh1_f" |  
−
| class="sshl_f" | 25752
+
| class="sshl_f" |  
−
| class=" " |
+
 
−
| class=" " |
 
−
| class=" " |
 
 
|- class="odd"
 
|- class="odd"
−
| Row3
+
| class="ssh1_f" |  
−
| class="    SelectTD ChangeBGColor SelectTD" |
+
| class="sshl_f" |  
−
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]  </div>
+
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
 
|- class="even"
 
|- class="even"
−
| Row4
+
| class="ssh1_f" |  
−
| class=" " |
+
| class="sshl_f" |  
−
| class=" " |
+
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="even"
 
−
| Row6
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
 
|}
 
|}
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
== See Also ==
−
----
+
 
 +
*[[Manuals/calci/OCT2HEX| OCT2HEX]]
 +
 
 +
*[[Manuals/calci/HEX2BIN| HEX2BIN]]
 +
 
 +
*[[Manuals/calci/HEX2DEC| HEX2DEC]]
 +
 
 +
==References==
 +
 
 +
*[http://simple.wikipedia.org/wiki/Hexadecimal_numeral_system Hexadecimal Numeral System]
 +
*[http://simple.wikipedia.org/wiki/Octal_numeral_system#Octal_and_hexadecimal Octal and Hexadecimal Numbers]

Revision as of 17:20, 4 December 2013

HEX2OCT(number,places)

  • Where 'number' is a hexadecimal number to be converted and
  • 'places' is the number of characters to be used to display the output.

HEX2OCT converts a hexadecimal number to its octal equivalent.

Description

HEX2OCT(number,places)

For Example,

HEX2OCT("A",4) returns '0012'

HEX2OCT("") returns

HEX2OCT("") returns


  • 'number' must be a hexadecimal number. Hexadecimal number uses digits 0 to 9 and characters A to F. The number can also be entered in text format (e.g "1F").
  • The most significant bit represents the 'sign' of the number. Negative numbers are represented using 2's complement notation.
  • A number preceding with '0' (e.g 013) should be written in text format ("013") to avoid confusion with octal numbers.
  • Calci returns an #ERROR message if 'number' contains more than 10 characters (10 bits).

Need to verify the 'limit for no. of input digits' after next release

  • If 'number' is negative, Calci ignores the places and displays 10 digit octal output.
  • If 'places' is not an integer, it is truncated.
  • If 'places' are non-numeric, Calci returns an #ERROR message.
  • If 'places' is negative, Calci ignores the places and displays the octal output.

Examples

HEX Input Octal Output

See Also

References

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/HEX2OCT&oldid=196155"