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.

Learn MS Excel


Ask Questions

Ask Question