< Go Back

Excel BIN2HEX Function

The TRUE function is a function in Excel which is grouped under the Engineering function. This function is used as a worksheet function (WS) which means it can be fixed into a formula in a cell of a worksheet.

What is the BIN2HEX Function in Excel?

The Excel BIN2HEX function returns hexadecimal (Base 16) numbers when provided with binary (Base 2) numbers.

Formula or Syntax

=BIN2HEX(number,[places])

Arguments or Parameters of the BIB2HEX Function

The BIN2HEX function syntax has the following arguments:

  • number (required) – The binary number to be converted to hexadecimal
  • places (optional) – The number of the characters the hexadecimal result will have. Places pads out the result with leading zeros up to the specified number of places. If omitted, the BIN2HEX returns the hexadecimal result to minimum place.

How to use the BIN2HEX Function in Excel?

The Excel BIN2HEX function returns hexadecimal numbers after converting the binary numbers provided. The example below should how to use the BIN2HEX function in Excel.

  • Let’s take this list of binary numbers into consideration as it is in below.

Figure 1. A list of binary numbers to convert with the BIN2HEX function.

  • The BIN2HEX function is applied to the table. The “number” parameter is inserted into the formula in the cell.

Figure 2. The BIN2HEX function showing “number” parameter.

  • The BIN2HEX function returns the hexadecimal equivalent of the binary numbers.

Figure 3. The BIN2HEX function returns hexadecimal numbers.

  • The “places” parameter is optional but if used, the results tend to be filled with zeros if they are not more than 10 characters.

Figure 4. The BIN2HEX function showing “places” parameter.

The #NUM! error values occurred because the number had a text character and was more than 10 characters.

Notes

  • The #NUM! error occurs when the character of number is not a binary number or is more than 10 characters.
  • The BIN2HEX returns #NUM! error value when it extends beyond the character of places provided.
  • The #NUM! error occurs when the character of places is negative.
  • The BIN2HEX returns the #Value error when the places is not a number.
Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar