BIN2HEX Function
The BIN2HEX function is used to convert a binary number to a hexadecimal number.
Formula:
=BIN2HEX(Number, Places)
Whereas Number is the binary number to be converted and Places is 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 convert a binary number to a hexadecimal number, using the BIN2HEX function, with the help of the below video.
