What is BIN2HEX function in Excel?
The BIN2HEX function is one of the Engineering functions of Excel.
It Converts a binary number to hexadecimal.
We can find this function in the Engineering category of insert function Tab.
How to use BIN2HEX function in excel
- Click on an empty cell (like F5 ).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select Engineering category.
5. Select BIN2HEX function.
6. Then select ok.
7. In the function arguments Tab you will see BIN2HEX function.
8. Number section is the binary number you want to convert.
9. Places is the number of characters to use.
10. You will see the results in the formula result section.
Examples of BIN2HEX function in Excel
Example 1:
How to use BIN2HEX function in excel
You can see examples of BIN2HEX function below:
bin2hex(A2) ----->>>>answer is 7F
bin2hex(A3) ----->>>>answer is 5C
bin2hex(A4) ----->>>>answer is 4F
bin2hex(A5) ----->>>>answer is FFFFFFFE01
bin2hex(A6) ----->>>>answer is 13FPurpose of BIN2HEX function
It Converts a binary number to hexadecimal.
Return value of BIN2HEX function
It returns a number and data.
Arguments of BIN2HEX function
This function has just 2 Argument.
The argument of BIN2HEX function is number.
Number section is the binary number you want to convert.
Places is the number of characters to use.
The argument of BIN2HEX function is required and not optional.
BIN2HEX(number) = number
Version of excel supports BIN2HEX function
This function is available for all excel versions (2003-2019)
