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.
• If 'places' is less than the number of output characters, Calci ignores the places and uses the minimum number of characters required to display the output.

Examples

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

See Also

• HEX2DEC

• HEX2OCT

• BIN2HEX

References

• Hexadecimal to Binary Conversion