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

Converts hexadecimal

numbers to binary

numbers.