Jump to navigation Jump to search
- Where is the hexadecimal number to be converted, and
- is the number of characters to display the output.
HEX2BIN() converts a hexadecimal number to its binary equivalent.
HEX2BIN("1EE",9) returns 111101110
HEX2BIN("4F",4) returns 1001111
- The 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 is not a valid hexadecimal number.
- argument is used to return the output with leading zeros. If argument is not used, 'Calci' uses the minimum number of characters required to display the binary output.
- If is negative, Calci ignores the places and uses the minimum number of characters required to display the binary output.
- If is not an integer, Calci rounds the value and uses the integer part as input.
- If is less than the number of output characters, Calci ignores the places and uses the minimum number of characters required to display the output.