Difference between revisions of "Manuals/calci/HEX2DEC"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''HEX2DEC'''</font></font><font face="Arial, san...")
 
Line 1: Line 1:
 +
=HEX2DEC(number, places)=
 +
 +
<font color="red">places argument to be included in upcoming version</font>
 +
 +
*Where 'number' is the hexadecimal number to be converted to decimal number.
 +
 +
HEX2DEC() converts a hexadecimal number to a decimal number.
 +
 +
== Description ==
 +
 +
HEX2DEC(number)
 +
 +
For example, HEX2DEC() ''returns 5'' as a result.
 +
 +
            HEX2DEC() ''returns 30'' as a result.
 +
 +
*This function is used to convert a hexadecimal number to a decimal number.
 +
*Hexadecimal number uses digits from 0 to 9 and characters from A to F.is represented using digits 1 or 0 only. The number can also be entered in text format (e.g "101").
 +
*The conversion can be obtained for a binary number upto 17 bits for positive numbers and 10 bits for negative numbers.
 +
*The most significant bit represents the 'sign' of the number (0=positive, 1=negative). Negative numbers are represented using 2's complement notation.
 +
 +
*Positive numbers may be from 0 (000000000) to 130046 (11111111111111110) and negative numbers from -1 (1111111111) to -512 (1000000000).
 +
 +
*A number preceding with '0' (e.g 01111111111) should be written in text format ("01111111111") to avoid confusion with octal numbers. 
 +
 +
*A binary number (e.g '101') is converted to decimal number (base 2) as -
 +
(1*2^2)+(0*2^1)+(1*2^0)=4+0+1= ''5''
 +
 +
*If the number is not a valid number, 'Calci' returns an #ERROR message.
 +
 +
Below are few examples that show the use of combination of functions and get the result in decimal -
 +
 +
1)SUM(BIN2DEC(100) + BIN2DEC(101)) ''returns 9'' as a result.
 +
 +
2)AVERAGE(BIN2DEC(100) + BIN2DEC(101)) ''returns 4.5'' as a result.
 +
 +
3)BIN2DEC(110)+BIN2DEC(101)-BIN2DEC(100) ''returns 7'' as a result.
 +
 
 +
 +
 +
 +
 +
 
<div id="6SpaceContent" class="zcontent" align="left">
 
<div id="6SpaceContent" class="zcontent" align="left">
  

Revision as of 16:11, 4 December 2013

HEX2DEC(number, places)

places argument to be included in upcoming version

  • Where 'number' is the hexadecimal number to be converted to decimal number.

HEX2DEC() converts a hexadecimal number to a decimal number.

Description

HEX2DEC(number)

For example, HEX2DEC() returns 5 as a result.

            HEX2DEC() returns 30 as a result. 
  • This function is used to convert a hexadecimal number to a decimal number.
  • Hexadecimal number uses digits from 0 to 9 and characters from A to F.is represented using digits 1 or 0 only. The number can also be entered in text format (e.g "101").
  • The conversion can be obtained for a binary number upto 17 bits for positive numbers and 10 bits for negative numbers.
  • The most significant bit represents the 'sign' of the number (0=positive, 1=negative). Negative numbers are represented using 2's complement notation.
  • Positive numbers may be from 0 (000000000) to 130046 (11111111111111110) and negative numbers from -1 (1111111111) to -512 (1000000000).
  • A number preceding with '0' (e.g 01111111111) should be written in text format ("01111111111") to avoid confusion with octal numbers.
  • A binary number (e.g '101') is converted to decimal number (base 2) as -
(1*2^2)+(0*2^1)+(1*2^0)=4+0+1= 5
  • If the number is not a valid number, 'Calci' returns an #ERROR message.

Below are few examples that show the use of combination of functions and get the result in decimal -

1)SUM(BIN2DEC(100) + BIN2DEC(101)) returns 9 as a result.

2)AVERAGE(BIN2DEC(100) + BIN2DEC(101)) returns 4.5 as a result.

3)BIN2DEC(110)+BIN2DEC(101)-BIN2DEC(100) returns 7 as a result.




HEX2DEC(num)

Where 'num' is the hexadecimal number.


This function ronverts a hexadecimal number to decimal.


HEX2DEC


 Lets see an example,

HEX2DEC(num)

=HEX2DEC("55") is 85

=HEX2DEC("3DA408B") is 64635019


Syntax

Examples

Description

Column1 Column2 Column3 Column4
Row1 85
Row2 64635019
Row3
Row4
Row5
Row6