Manuals/calci/HEX2BIN

HEX2BIN(number, places)

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

HEX2BIN() converts a hexadecimal number to its binary equivalent.

Description

HEX2BIN(number, places)

For example,

HEX2BIN("1EE",9) returns 111101110

HEX2BIN("4F",4) returns 1001111

• The 'number' can be maximum of 10 characters (40 bits). If it exceeds the limit, Calci gives a #NUM! error.
• Hexadecimal number uses numbers from 0 to 9 and characters from A to F. Hence, the number argument should be entered in quotes (e.g. "1FF").
• The most significant bit of the number is the sign bit and remaining bits are magnitude bits. A negative number is represented in 2's complement form.
• Calci returns an #ERROR message, if the 'number' is not a valid hexadecimal number.
• 'places' argument is used to return the output with leading zeros. If 'places' argument is not used, 'Calci' uses the minimum number of characters required to display the binary output.
• If 'places' is negative, Calci ignores the places and uses the minimum number of characters required to display the binary output.
• If 'places' is not an integer, Calci rounds the value and uses the integer part as input.

Examples

Function	Binary Output
HEX2BIN("A",5)	01010
HEX2BIN("10",8)	00010000
HEX2BIN("FFFFFFFE00")	1000000000
HEX2BIN("0FF",-5)	11111111
HEX2BIN("DF")	0011011111

See Also

• DEC2HEX

• DEC2OCT

• BIN2DEC

References

• Decimal Numbers