HEX2BIN() function
About HEX2BIN() function
The HEX2BIN() function is an Engineering function that converts a hexadecimal number into binary number. It keeps a single argument that is number.
Where to apply :
This function is used by engineers where machines need to convert the hexadecimal number into binary number. It is also used in education.
Syntax :
=HEX2BIN(number)
Parameters :
number- A hexadecimal number.
Example:
1. For the hexadecimal number is F.
=HEX2BIN(F) // Returns (1111)
It returns 1111 for the hexadecimal number F.
Excel based example:

The HEX2BIN() function is well explained in above image.
Hope, it would have added in your Excel function knowledge.
Thank You!
Best Excel training institute in Noida provides Basic Excel, Advance Excel and VBA offline and online classes.
If you want to learn Excel & VBA courses to be Excel expert, connect us on:
ExcelHour
9599408486 / 8929231250
Website: https://www.excelhour.in/