Microsoft Office Tutorials and References

In Depth Information

**DEC2HEX**

DEC2HEX

Convert decimal numbers to hexadecimal with the
DEC2HEX
function.

=DEC2HEX(number,places)

The
DEC2HEX
function is found only if the Analysis Toolpak is installed. In addition it must be

turned on in the Add-Ins from the Tools menu. The number returned is a 10 character

hexadecimal number. The sign bit being the most significant, the remaining 39 bits are magnitude

bits. Negatives are represented using Two’s complement notation. Notice the example in

Figure 5.11. Where the Binar y Number is 10000010 and the Places is 3, the conversion to

Octal results in 202.

The number to convert.

NUMBER

The number of characters to use. 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.11

Converting decimal

numbers to hexadecimal

numbers.

DELTA

DELTA
tests whether numbers or values are equal with a number result—sometimes referred

to as Kronecker.

=DELTA(number1,number2)

The
DELTA
function is found only if the Analysis Toolpak is installed. In addition it must be

turned on in the Add-Ins from the Tools menu. If the first number is 1 and the second

number is 2, the result is 0. However if the first number 1 and the second number is 1 the result

is 1. Similar to a True or False logical test except the return is a number instead of a text

result. Notice the example in Figure 5.12.

The first number.

NUMBER 1

The second number. If omitted, assumes 0.

NUMBER 2