Difference between revisions of "Manuals/calci/OCT2HEX"

From ZCubes Wiki
Jump to navigation Jump to search
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
=OCT2HEX(number, places)=
 
=OCT2HEX(number, places)=
  
*Where 'number' is an octal number to be converted and
+
*Where <math>number</math> is an octal number to be converted and
*'places' is the number of characters to be used to display the output.
+
*<math>places</math> is the number of characters to be used to display the output.
  
 
OCT2HEX() converts an octal number to its hexadecimal equivalent.
 
OCT2HEX() converts an octal number to its hexadecimal equivalent.
Line 17: Line 17:
 
OCT2HEX(777,3) ''returns 1FF''
 
OCT2HEX(777,3) ''returns 1FF''
  
*The 'number' can be upto 9 digits. The most significant bit is the sign bit and remaining bits are magnitude bits.
+
*The <math>number</math> can be upto 9 digits. 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 7 digit hexadecimal number.
+
*If the <math>number</math> is negative, Calci ignores the places and returns a 7 digit hexadecimal number.
<font color=blue> Need to check the input and output limits after next release</font>
+
*If the <math>number</math> is not an integer, Calci displays an #NUM! error message.
*If the 'number' is not an integer, Calci displays an #NUM! error message.
+
*If the <math>number</math> is an invalid octal number, Calci displays an #NUM! error message.
*If the 'number' is an invalid octal number, Calci displays an #NUM! error message.
+
*<math>places</math> argument can be omitted. Calci displays the hexadecimal output with minimum number of characters necessary.
*'places' argument can be omitted. Calci displays the hexadecimal output with minimum number of characters necessary.
+
*<math>places</math> is used for padding the output with leading '0's'.
*'places' is used for padding the output with leading '0's'.
+
*Calci ignores the <math>places</math>, if the output is more than mentioned 'places'.
*Calci ignores the 'places', if the output is more than mentioned 'places'.
+
*If <math>places</math> is non-numeric or negative, Calci displays an error message.
*If the 'places' is non-numeric or negative, Calci displays an error message.
+
*If <math>places</math> is not an integer, Calci truncates the 'places' value.
*If 'places' is not an integer, Calci truncates the 'places' value.
 
 
*A number preceding with '0' (e.g. 0377) should be written in text format ("0377") to avoid confusion with hexadecimal numbers.
 
*A number preceding with '0' (e.g. 0377) should be written in text format ("0377") to avoid confusion with hexadecimal numbers.
  
Line 50: Line 49:
 
| class="sshl_f" | 7FFFFFF
 
| class="sshl_f" | 7FFFFFF
 
|}
 
|}
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|t3Wn-mjT-DM|280|center|OCT2HEX}}
  
 
== See Also ==
 
== See Also ==

Latest revision as of 15:18, 27 April 2015

OCT2HEX(number, places)

  • Where is an octal number to be converted and
  • is the number of characters to be used to display the output.

OCT2HEX() converts an octal number to its hexadecimal equivalent.

Description

OCT2HEX(number, places)

For Example,

OCT2HEX(300,4) returns 00C0

OCT2HEX(23,5.5) returns 000013

OCT2HEX(777,3) returns 1FF

  • The can be upto 9 digits. The most significant bit is the sign bit and remaining bits are magnitude bits.
  • If the is negative, Calci ignores the places and returns a 7 digit hexadecimal number.
  • If the is not an integer, Calci displays an #NUM! error message.
  • If the is an invalid octal number, Calci displays an #NUM! error message.
  • argument can be omitted. Calci displays the hexadecimal output with minimum number of characters necessary.
  • is used for padding the output with leading '0's'.
  • Calci ignores the , if the output is more than mentioned 'places'.
  • If is non-numeric or negative, Calci displays an error message.
  • If is not an integer, Calci truncates the 'places' value.
  • A number preceding with '0' (e.g. 0377) should be written in text format ("0377") to avoid confusion with hexadecimal numbers.

Examples

Function HEX Output
OCT2HEX(511) 0000149
OCT2HEX(433,3) 11B
OCT2HEX(777777777) 7FFFFFF

Related Videos

OCT2HEX

See Also

References