You can convert binary numbers into hexadecimal numbers

The binary numbers contain only 0 and 1 values

Oct numbers contain 0 to 15 values

BIN2HEX Function has a limit of 10 characters

If you write more than 10 characters it will return #NUM error

Syntax

=BIN2HEX(number,[places])

Argument

Number: it is the number you want to convert into octal

Places:[Optional] how many characters you want to show in your result. It will place "0" before the result.

Behavior

Here we have taken an example of the binary number and convert it into HexaDecimal numbers. We have written a formula

On the right side, if you write 10 times "1" it will return 10 times "F"

If you write more than 10 characters it will return #NUM error

*Usage*

To convert a Binary number into a hexadecimal number

*Returns*

HexaDecimal number

## No comments:

## Post a Comment