Difference between revisions of "Manuals/calci/HEX2DEC"

From ZCubes Wiki
Jump to navigation Jump to search
Line 25: Line 25:
 
Below are few examples that show the use of combination of functions and get the result in decimal -
 
Below are few examples that show the use of combination of functions and get the result in decimal -
  
1)SUM(HEX2DEC("FF") + HEX2DEC("57")) ''returns 342'' as a result.  
+
1)SUM(HEX2DEC("FF"),HEX2DEC("57")) ''returns 342'' as a result.  
  
 
2)HEX2DEC("65") - HEX2DEC("42") ''returns 35'' as a result.
 
2)HEX2DEC("65") - HEX2DEC("42") ''returns 35'' as a result.

Revision as of 09:56, 11 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("F") returns 15 as a result.

HEX2DEC("01D") returns 29 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. The number can also be entered in text format (e.g "1F").
  • A number preceding with '0' (e.g 013) should be written in text format ("013") to avoid confusion with octal numbers.
  • A number can be up to 10 characters (40 bits). The most significant bit is the sign bit and remaining are magnitude bits. A negative number is represented in 2's complement format.
  • 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(HEX2DEC("FF"),HEX2DEC("57")) returns 342 as a result.

2)HEX2DEC("65") - HEX2DEC("42") returns 35 as a result.

Examples

HEX Input Decimal Output
85 133
110 272
FFAFFAFFA 68635570170
FFFFFFFFFF -1

See Also

References