HEX2BIN Function in Excel

In this article, you will learn about the HEX2BIN function, its usage, syntax and how to use it in your excel spreadsheet

HEX2BIN Function in Excel

The HEX2BIN function in Excel converts a hexadecimal number to its binary value.

Syntax 

=HEX2BIN (number, [places])

Arguments 

• number – The hexadecimal number you want to convert to binary number.
• places – [optional]

When left out or neglected, it uses the least number of characters required to represent the number, or else it combines the result with zeros up to the specified number of places.

Possible Errors

• When the given number is negative, HEX2BIN ignores the second argument ‘places’ and returns a 10-character binary number.
• When the given hexadecimal number is not a valid hexadecimal number, HEX2BIN returns the #NUM! error value.
• And in the case of HEX2BIN requiring more than places characters, it returns the #NUM! error value.
• When the number is not an integer, it is truncated.
• When the second argument ‘places’ is non-numeric, HEX2BIN returns the #VALUE! error value.
• And when the ‘places’ is negative, HEX2BIN returns the #NUM! error value.

How to use HEX2BIN in Excel?

Using this function in your excel worksheet is simple; all you need to do is enter the function as a formula of the cell in the formula bar.

Take a look at the given example

The above numbers are the Hexadecimal version of some binary numbers. To find out the binary numbers, Enter the given Hexadecimal numbers in column A and in Column B enter the places, and in C column enter the following formula

Formula: =HEX2BIN(A1,B1)

Here, A1 refers to the cell name or the cell address. Repeat the same to the other cells and you will get the binary values of the Hexadecimal value.