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...")
 
 
(9 intermediate revisions by one other user not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
=HEX2OCT(number,places)=
  
−
'''HEX2OCT'''(SomeNumber, NumberPlaces)
+
*Where <math>number</math> is a hexadecimal number to be converted and
 +
*<math>places</math> 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("FA",6) ''returns 000372''
−
----
 
−
<div id="7SpaceContent" class="zcontent" align="left">
 
  
−
If SomeNumber and NumberPlaces are non-numeric, HEX2BIN returns the#ERROR.
+
HEX2OCT("09") ''returns 0000000011''
  
−
If the NumberPlaces is a negative, it returns the #ERROR.
+
*<math>number</math> 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 NumberPlaces &gt; LengthofSomeNumber then  returns #ERROR.
+
*The most significant bit represents the 'sign' of the number. Negative numbers are represented using 2's complement notation.
  
−
If number is not valid hexadecimal number, it returns NaN.
+
*A number preceding with '0' (e.g 013) should be written in text format ("013") to avoid confusion with octal numbers.
  
−
</div>
+
*Calci returns an #ERROR message if <math>number</math> is greater than 'FFFFFFF'.
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
HEX2OCT
+
*If <math>number</math> is negative, Calci ignores the places and displays 10 digit octal output.
  
−
<font size="6"></font>
+
*If <math>places</math> is not an integer, it is truncated.
  
−
</div></div>
+
*If <math>places</math> are non-numeric, Calci returns an #ERROR message.
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left">
 
  
−
Lets see an example in (Column1, Row1)
+
*If <math>places</math> is negative, Calci displays #NUM! error message.
  
−
<nowiki>=HEX2OCT("A",4)</nowiki>
+
*If <math>places</math> is omitted, Calci displays the 10 digit octal output by adding the leading zeros (if required).
  
−
HEX2OCT converts A to 0012 upto 4 charcacters.
+
*If <math>places</math> is less than the digits required by the output, Calci ignores the places and uses the minimum number of digits required to display the octal output.
  
−
Consider an another example(Column1, Row2)
+
== Examples ==
−
 
 
−
<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" | HEX2OCT("44F",5)
−
| class="sshl_f" | 12
+
| class="sshl_f" | 02117
−
| class=" " |
+
 
−
| class=" " |
 
−
| class=" " |
 
 
|- class="even"
 
|- class="even"
−
| class=" " | Row2
+
| class="ssh1_f" | HEX2OCT("17")
−
| class="sshl_f" | 25752
+
| class="sshl_f" | 0000000027
−
| class=" " |
+
 
−
| class=" " |
 
−
| class=" " |
 
 
|- class="odd"
 
|- class="odd"
−
| Row3
+
| class="ssh1_f" | HEX2OCT("D1C",-3)
−
| class="     SelectTD ChangeBGColor SelectTD" |
+
| class="sshl_f" | #NUM!
−
<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" | HEX2OCT("FFFFFFF")
−
| class=" " |
+
| class="sshl_f" | 1777777777
−
| 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>
+
==Related Videos==
−
----
+
 
 +
{{#ev:youtube|KgYrP4m4jPM|280|center|HEX2OCT}}
 +
 
 +
== 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]

Latest revision as of 01:12, 26 October 2015

HEX2OCT(number,places)

  • Where is a hexadecimal number to be converted and
  • 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("FA",6) returns 000372

HEX2OCT("09") returns 0000000011

  • 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 is greater than 'FFFFFFF'.
  • If is negative, Calci ignores the places and displays 10 digit octal output.
  • If is not an integer, it is truncated.
  • If are non-numeric, Calci returns an #ERROR message.
  • If is negative, Calci displays #NUM! error message.
  • If is omitted, Calci displays the 10 digit octal output by adding the leading zeros (if required).
  • If is less than the digits required by the output, Calci ignores the places and uses the minimum number of digits required to display the octal output.

Examples

HEX Input Octal Output
HEX2OCT("44F",5) 02117
HEX2OCT("17") 0000000027
HEX2OCT("D1C",-3) #NUM!
HEX2OCT("FFFFFFF") 1777777777

Related Videos

HEX2OCT

See Also

References

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