Manuals/calci/HEX2BIN
HEX2BIN(SomeNumber, NumberPlaces)
where,
SomeNumber - is the hexadecimal number.
NumberPlaces - is the number of characters.If omitted then it use minimum number of characters.NumberPlaces is use for adding the return value with leading zero.
Calci converts a hexadecimal number to binary number.
If SomeNumber and NumberPlaces are non-numeric, HEX2BIN returns the#ERROR.
If the NumberPlaces is a negative, it returns the #ERROR.
If NumberPlaces > LengthofSomeNumber then returns #ERROR.
If number is not valid hexadecimal number, it returns #ERROR.
If NumberPlaces > 10 ,then it returns #ERROR.
HEX2BIN
Lets see an example in (Column1, Row1)
=HEX2BIN("A",5)
HEX2BIN converts A to 01010.
Consider an another example(Column1,Row2)
=HEX2BIN("C3")
Converts C3 to 11000011.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 1010 | |||
| Row2 | 11000011 | |||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
