HEX2BIN Function
The HEX2BIN () is an engineering function which takes ‘number’ and ‘places’ as argument and converts a hexadecimal number to a binary number.
Formula:
=HEX2BIN(number, places)
In the above syntax, the argument number denotes the hexadecimal number to be converted and Places denotes the number of characters to use. The "Number" should not be more than 10 digits. The first bit is sign bit and the remaining 9 bits are magnitude bits. Negative numbers are represented using two's-complement notation.
Video Tutorial:
Let us see how the HEX2BIN function converts a hexadecimal number to binary number with the help of the below video.
