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
Search JabSto ::




Custom Search