Microsoft Office Tutorials and References
In Depth Information
HEX2BIN
Figure 5.15
Returns the value of 1
if the number is greater
than or equal to the
step, otherwise 0.
HEX2BIN
Convert hexadecimal numbers to binar y with the HEX2BIN function.
=HEX2BIN(number,places)
HEX2BIN is found only if the Analysis Toolpak is installed. In addition it must be turned on in
the Add-Ins from the Tools menu. Notice the example in Figure 5.16. The binar y number is
converted to a hexadecimal and then the HEX2BIN function converts the hexadecimal back to
a binar y number. The number cannot be more than 10 characters. The sign bit being the
most significant, the remaining 9 bits are magnitude bits. Negatives are represented using
Two’s complement notation.
The number to convert. Cannot be less than –512 or greater than
511.
NUMBER
The number of characters to use. If places is omitted it uses the
least characters necessar y. If the value is not an integer, the value
is truncated. Use when you want to pad the result with leading
zeros to achieve uniformity.
PLACES
Figure 5.16