Microsoft Office Tutorials and References
In Depth Information
DEC2BIN
Figure 5.9
Converts measurement
units from one unit to
another.
DEC2BIN
The DEC2BIN function converts decimal numbers to binar y.
=DEC2BIN(number,places)
DEC2BIN 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 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. Notice the example in Figure 5.10. Where the
Decimal Number is 2 and the Places is 3, the conversion to a binar y results in 010.
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.10
Converts decimals to
binary numbers.
Search JabSto ::




Custom Search